» Sum Total Sales Except for One Specified Item
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Columns A & B contain clothing items and their matching total sales.
We want to create a formula that will sum the sales from column B of all items except the jacket.
Solution:
Use the SUMIF function as shown in the following formula:
=SUMIF(A2:A6,"<>Jacket",B2:B6)
Book Store:
Recommended Books:
- Definitive Guide to Excel VBA
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Business Plans For Dummies®
- The Basics of Finance: Financial Tools for Non Financial Managers
No comments have been submitted.
