Microsoft Office Tutorials and References
In Depth Information
COUNTA
You can specify up to 30 arguments for the COUNT function. The
arguments can be cell references, arrays, or range names. Blank cells or
cells containing text are ignored. Cells that contain a zero (0) or dates
are included in the COUNT calculation.
VALUE N
Figure 11.8
Numbers with symbols
are treated as text by
Excel and are therefore
not included in the
COUNT function
calculation.
1
Treated as text
by Excel
COUNTA
COUNTA counts the number of cells that are not empty.
=COUNTA(value1,value2,...)
Use the COUNTA function to count the number of cells in a range that contain text, numbers, or
a combination of text and numbers. Although you can use COUNTA to generate the number of
clients or employees in a list, it counts each entr y, not unique entries.
To count unique entries, combine the SUM and the COUNTIF functions. For example, if the range to
be counted is C6:C46, the formula would be:
TIP
=SUM(1/COUNTIF(C6:C46,C6:C46))
You must array-enter the formula (using Ctrl+Shift+Enter) for this formula to count properly.
Refer to Figure 11.8 for a comparison between the COUNT and the COUNTA functions.
You can specify up to 30 arguments for the COUNTA function. The
arguments can be cell references, arrays, or range names. Blank
cells are ignored. All other cells are counted.
VALUE N
COUNTBLANK
COUNTBLANK counts the empty cells in a specified range.
=COUNTBLANK(range)
RANGE
Is the range to be counted.
Search JabSto ::




Custom Search