Conditional sum error with array size mismatch

Hello, I am not able to solve this issue because I keep getting errors that the size of the arrays (column) don't match.


I have 3 tables (Table 1, 2, 3). The first table contains values and a year associated with that value.

The second table contains a list of years and a checkbox.

I need to SUM the values in Table 1 but only if the corresponding year in Table 2 is checked.

I need to be able to check multiple years in Table 2 and the values found in Table 1 for the corresponding year will be SUM-ed and displayed in Table 3.


I've tried using numerous function (eg sumif(s), countif(s), match, lookup, etc) but I always get an error, usually because Table 1 contains more rows than Table 2 and it says I need the same number of rows in both.


Appreciate any hints.


[Edited by Moderator]

Posted on Jun 30, 2026 3:34 AM

Reply
1 reply

Conditional sum error with array size mismatch

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.