» 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:
- Windows XP for Dummies
- Definitive Guide to Excel VBA
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- The One Page Business Plan: Start With a Vision, Build a Company!
- How to Read A Financial Report
No comments have been submitted.
