» Checking Whether Cells in a Range are Blank, and Counting the Blank Cells
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Checking whether or not each of the cells in List1 (column A) is blank, and Counting the Blank Cells.
Solution:
Use either of the following formulas in column B:
=IF(ISBLANK(A2),"",A2)
=IF(A2="","",A2)
Either formula will return the corresponding value from column A only if the cell is not blank.
Use the COUNTBLANK function, as shown in the following formula, to count the number of blank cells in List1:
=COUNTBLANK(A2:A7)
Book Store:
Recommended Books:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft Windows XP Registry Guide
- Guide to Financial Reporting and Analysis
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Analyzing Markets, Products, and Marketing Plans
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.


