» Totaling Two Ranges Using the SUMIF Formula
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
To let the SUMIF formula add or subtract amounts from different ranges, insert two SUMIF formulas and combine them into a single formula:1. Insert the SUMIF formula to total the amounts based on the criterion 701 into cell E2.
2. Insert the SUMIF formula to total the amounts based on the criterion 300 into cell E3.
3. Select cell E2 and copy the formula from the Formula Bar, select the formula and press Ctrl+C and click the Enter or Cancel symbol in the Formula Bar to exit Edit mode.
4. Select cell E5 and press Ctrl+V.
5. Select cell E3 and copy the formula from the Formula Bar without the equals (=) sign by selecting the formula and pressing Ctrl+C.
6. Select cell E5 and enter a minus (-) sign after the formula in the cell, and then press Ctrl+V.
The combined formula is now:
=SUMIF(A:A,D2,B:B)-SUMIF(A:A,D3,B:B).
Book Store:
Recommended Books:
- Microsoft Windows XP Inside Out
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- The Basics of Finance: Financial Tools for Non Financial Managers
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
No comments have been submitted.
