COUNT ()
This function counts the number of numeric entries in a list.
Best view in desktop mode.
A
|
B
|
C
|
D
|
|
1
|
Values
|
Count
|
||
2
|
50
|
4
|
||
3
|
=COUNT(A2:A10)
|
|||
4
|
Andrew
|
|||
5
|
20%
|
|||
6
|
Simple
|
|||
7
|
25.52
|
|||
8
|
9-Mar-20
|
|||
9
|
#DIV/0!
|
|||
10
|
FALSE
|
|||
11
|
- It ignores blanks cells.
- It ignores text value.
- It ignores errors.
- It ignores logical values TRUE or FALSE
- It can handle up to 255 arguments or ranges.
Syntax
=COUNT(Range1,Range2,Range3...
through to Range30)
Formatting
No special
formatting is needed. The result will display as normal text.
Functions for
Counting
Ø To count only numbers, use COUNT()
Ø To count numbers and text value, use COUNTA()
Ø To count based on one criteria, use COUNTIF()
Ø To count based on multiple criteria, COUNTIFS()
Ø To count blank cells, use COUNTBLANK()
No comments:
Post a Comment