» Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
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:
- Business Plans Kit for Dummies (With CD-ROM)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Mortgages For Dummies®
- Financial Reporting and Analysis (2nd Edition)
- Business Analysis with Microsoft Excel (2nd Edition)
- The One Page Business Plan: Start With a Vision, Build a Company!
No comments have been submitted.
