|  

» Ignoring Blank Cells when Performing Calculations

Problem:

Columns A & B contain numbers as well as empty cells.
We want to be able to multiply each number in column A with the matching number in Column B without getting false results or errors.

Solution:

Use IF, AND and ISNUMBER functions in the following formula:
=IF(AND(ISNUMBER(A2), ISNUMBER(B2)),A2*B2," ")



Example:


List1___List2___Result
2_______3_______6
5
8
11______4_______44


Screenshot // Ignoring Blank Cells when Performing Calculations
Ignoring Blank Cells when Performing Calculations

Rate This Tip
12 34 5
Rating: 3.02     Views: 59531
No comments have been submitted.
Name
Comment Title
Comments