» 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:
- Marketing Plan: A Handbook with Marketing Plan
- The Ernst & Young Business Plan Guide
- Not-for-Profit Accounting Made Easy
- Positioning: The Battle for Your Mind
- Microsoft Windows XP Step by Step (With CD-ROM)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
