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

by  About
       

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<>”"))
Screenshot // Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
Summing Values Based on the Criteria of a Non-Empty Adjacent Cell



Leave a Reply

Your email address will not be published. Required fields are marked *


− three = 3

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>