» 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:
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- The Fall of Advertising and the Rise of PR
- Windows XP Annoyances
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Flipping Properties: Generate Instant Cash Profits in Real Estate
No comments have been submitted.
