Sumif multiple columns

[tiredofit]

Assume I have this data over 3 columns:

Apples    1   2
Oranges  3   4
Apples    5    6

I thought this would return 14, ie 1+2+5+6

=SUMIF(A1:A3,"Apples",B1:C3)

but it only returns 6, ie 1+5

What is wrong?

Thanks

 

[gaz_chops]

Try

=SUMPRODUCT((A1:A3="Apples")*(B1:C3))

 

[tiredofit]

Thanks.

If my memory serves me well, I seem to recall my formula (without using Sumproduct) works in Excel 2016.

Can someone please verify.

 

[RoryA]

No. The ranges for SUMIF need to be the same size.

 

[tiredofit]

Thanks