How do I add only the negative or only the positive numbers in a selected range?
S slowes Nov 8, 2006 #1 How do I add only the negative or only the positive numbers in a selected range?
M MrAcquire Nov 8, 2006 #2 To sum negative numbers only in a selected range, =SUMIF(range,"<0") To sum positive numbers only in a selected range, =SUMIF(range,">0")
To sum negative numbers only in a selected range, =SUMIF(range,"<0") To sum positive numbers only in a selected range, =SUMIF(range,">0")
J Jaleel Nov 8, 2006 #3 Hi, In another cell put =SUMIF(range,"<0") to get the total of negative numbers and =SUMIF(range,">0") for the total of positive numbers. Regards, Jaleel
Hi, In another cell put =SUMIF(range,"<0") to get the total of negative numbers and =SUMIF(range,">0") for the total of positive numbers. Regards, Jaleel
