Summing Positive and Negative Numbers Separately

by  About


Calculating separate totals for the negative numbers and the positive numbers in List1 (column A).


Use the SUMIF function as shown in following formulas:
To sum negative numbers:
To sum positive numbers:

Leave a Reply

Your email address will not be published. Required fields are marked *

× 7 = fifty six

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>