» Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Problem: Summing each of the numbers in column A (List 1), provided that the adjacent cell in column B (List 2) is not empty.
Solution 1:
Use the SUMIF function as shown in the following formula:
=SUMIF(B2:B7,"<>",A2:A7)
Explanation:
The SUMIF function adds all the values in column A that have non-empty corresponding cells in column B.
Solution 2:
Use the SUMPRODUCT function as shown in the following formula:
=SUMPRODUCT(A2:A7*(B2:B7<>""))
Book Store:
Recommended Books:
- Harry Potter and the Order of the Phoenix (Book 5)
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Now, Discover Your Strengths
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Microsoft Access 2002 for Dummies
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
