» Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
Summing each of the numbers in column A (List 1), provided that the adjacent cell in column B (List 2) is not empty.
Use the SUMIF function as shown in the following formula:
The SUMIF function adds all the values in column A that have non-empty corresponding cells in column B.
Use the SUMPRODUCT function as shown in the following formula:
|Screenshot // Summing Values Based on the Criteria of a Non-Empty Adjacent Cell|