Microsoft Office Tutorials and References
In Depth Information
COUNTBLANK
Table 7.2
Continued
If Format Is…
Cell Returns…
0.00
,F2
#,##0.00
,2
$#,##0_);($#,##0)
C0
$#,##0_);[Red]($#,##0)
C0-
$#,##0.00_);($#,##0.00)
C2
$#,##0.00_);[Red]($#,##0.00)
C2-
0%
P0
0.00%
P2
0.00E+00
S2
#?/?or#??/??
G
m/d/yy or m/d/yyh:mm or mm/dd/yy
D4
d-mmm-yy or dd-mmm-yy
D1
d-mmm or dd-mmm
D2
mmm-yy
D3
mm/dd
D5
h:mm AM/PM
D7
h:mm:ss AM/PM
D6
h:mm
D9
h:mm:ss
D8
COUNTBLANK
COUNTBLANK counts the number of empty cells in a specified range.
=COUNTBLANK(range)
The COUNTBLANK function returns the number of blank cells. If you have a formula that returns
a blank text result, that cell is also counted. Notice the example in Figure 7.2, the COUNTBLANK
function can be used to track percent complete in tables where you have steps in process.
This is the range your looking for blank cells in.
RANGE
Search JabSto ::




Custom Search