Say I have a column of numbers and I want to add up only the odd numbers. I tried SUMIF(A1:A10,"ISODD",A1:A10) to no avail.
But, curiously, if I altered the formula to SUMIF(A1:A10,">5",A1:A10) it did in fact add up only the numbers that were > 5.
The syntax seems the same to me, so why the difference?
So then I tried =SUMPRODUCT(--ISODD(A1:A10),A1:A10) also to no avail.
But VERY curiously, the following formula did work to add up just the odd rows =SUMPRODUCT(--ISODD(ROW(A1:A10)),A1:A10)
Can someone explain (in simple terms, please) what concept(s) I'm missing? I don't want to just ask someone to write the formula for me, I want to understand why it works. Thanks!
Bookmarks