» 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:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- The New Financial Order: Risk in the Twenty-First Century
- Word 2002: The Complete Reference
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
No comments have been submitted.
