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]