» 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:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Analyzing Markets, Products, and Marketing Plans
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Business Analysis with Microsoft Excel (2nd Edition)
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Microsoft Windows XP Step by Step (With CD-ROM)
No comments have been submitted.
