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,D3:D500)+SUMIF(C3:C500,C3,E3:E500)
Is this normal behavior or is something wrong?
--Carlos
Bookmarks