Tip Printed from ExcelTip.com

---

Summing Values Based on the Criteria of a Non-Empty Adjacent Cell


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<>""))