Simple SumIf Not Working

Try

im M4

Formula:

Please Login or Register  to view this content.

Copy across

Do NOT use full column ranges with SUMPRODUCT

For SUMIF the range to summed must the same size as the criteria range: hence you cannot sum 2 columns i.e H:I

To play and learn with another formula.

Formula:

Please Login or Register  to view this content.

And two other functions for you to study.

Formula:

Please Login or Register  to view this content.

Pl see file. Note changes in L8:L10
For any version
In M8, copied down

=SUMPRODUCT(($A$2:$A$25=L8)*($I$2:$I$25+$H$2:$H$25))

For 365 version. In N8

=BYROW(L8:L10,LAMBDA(ro,SUMPRODUCT((A2:A25=ro)*(I2:I25+H2:H25))))

Thank you DJunqueira! I tested it and of course it works. I read both your posts and appreciate some alternatives (ByColand Transpose) to play with. It makes sense once I see it, but sometimes I can't seem to get the nuance. Thank you!


Thank you JohnTopley! I copied this and working through it. Appreciate the explanation of SumIf and SumProduct. It gives me an alternative to explore.


Thank you kvsrinisvasamurthy! Appreciate the sample and the ByRow example as another way to look at it.


Really some great things to look at from all three of you. There is so much in Excel that I don't use and it's always interesting to learn something new. I'm glad there is a resource like this to get help!