|  

» Count the number of blank cells in a range in Microsoft Excel

CATEGORY - Counting VERSION - All Microsoft Excel Versions
Assume Range A1:B15 (14 cells out of the 30 contain data)

Use the following function: =COUNTBLANK(A1:B15)

The result: 16


Rate This Tip
12 34 5
Rating: 4.40     Views: 37411
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments