Quote:
Originally Posted by Wesler
Here's the function to get the negative numbers, which works. When I inverse the operator, it doesn't. Makes no sense I know, but such is Excel or my using of it.
=SUMIF((F13),(K13),(P13),(U13),(Z13),(F28),(K28),( P28),(U28),(Z28),(K43),...,(Z193))"<0")
|
I also don't know how this formula worked for you as this is not the correct form of the SUMIF formula.
If your data lies in the range F13:Z193, then try using this
SUMIF(F13:Z193,"<0") this sums all the numbers whose value <0. Substitute <0 with 0 to get the sum of positive values. Should work.