» Summing Positive and Negative Numbers Separately
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: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:
Recommended Books:
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Special Edition Using Microsoft Outlook 2002
- Advanced modelling in finance using Excel and VBA
- Adventure Capitalist: The Ultimate Road Trip
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Excel 2002 Power Programming with VBA
No comments have been submitted.
