SUMIF question

[CarlosAntenna]

I have a formula that attempts to use SUMIF to sum a range that includes two
columns.

=SUMIF(C3:C500,C3,D3:E500)

The result of this formula is the sum of column D only.
I had to break it down as follows:

=SUMIF(C3:C500,C3,D3500)+SUMIF(C3:C500,C3,E3:E500)

Is this normal behavior or is something wrong?

--Carlos

 

[Peo Sjoblom]

Yes it is normal behaviour, in SUMIF the corresponding sum range needs to be
of the same size, you can use

=SUMPRODUCT((C3:C500=C3)*(D3:E500))

 

[CarlosAntenna]

Thanks Peo, I have never used SUMPRODDUCT before but there is always a first
time. This must be it.

-- Carlos