» Summing Positive and Negative Numbers Separately
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Calculating separate totals for the negative numbers and the positive numbers in List1 (column A).
Solution:
Use the SUMIF function as shown in following formulas:
To sum negative numbers:
=SUMIF(A2:A7,"<0")
To sum positive numbers:
=SUMIF(A2:A7,">0")
Book Store:
thanks man
agus
thanks man....this is very helpful
My favourite pharma supermarket www.world-viagra.com
mymalifexx
+1
Best wishes,
Alex
[url]http://www.world-viagra.com[/url] - best cheap pharmacy shop
