In the above example, we have both blank and non-blank cells in the range of A1 to A11. We had calculated the count of blank cells in this range using the above referred formula.
March 1, 2010
Counting of blank cells in range
We can count the blank cells in a range, using =COUNTBLANK(A1:A11) formula. For example if you have blank and non-blank cells in a range and you would like to count the number blank cells. We can count them, please have a look at the below example.
In the above example, we have both blank and non-blank cells in the range of A1 to A11. We had calculated the count of blank cells in this range using the above referred formula.
In the above example, we have both blank and non-blank cells in the range of A1 to A11. We had calculated the count of blank cells in this range using the above referred formula.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment