Sumifs with an array (to add up columns of data)

[anon]

Hey,

I have a table of data and I want to use sumifs to add up columns of data. Any way to do that?

For example:

a | b | a | d | a
1 | 2 | 3 | 4 | 5
6 | 7 | 8 | 9 | 10

I want to add up all the cells with A in the header. Something like:

=sumifs(A2:E3,A1:E1,"a")
which should give you 1 + 3 + 5 + 6 + 8 + 10 = 33

-except that formula doesn't work...

Thanks!

[XOR LX]

Hi.

=SUMPRODUCT((A1:E1="a")*A2:E3)

Regards

[romperstomper]

BTW, SUMIFS expects the criteria and sum ranges to be the same size, which is why you have to use SUMPRODUCT as XOR LX suggested.