» Ignoring Blank Cells when Performing Calculations
CATEGORY - Excel Array Formulas
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Accounting the Easy Way
- Seven Habits Of Highly Effective People
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.
