COUNT
This function counts the number of numeric entries in a list.
It will ignore blanks, text and errors.
A B C Count
10 20 30 3
10 30 2
10 -20 30 3
10 1-Jan-88 30 3
10 21:30 30 3
BB 1 CC 1
354 #DIV/0! 487 2
COUNTA
This function counts the number of numeric or text entries in a list.
It will ignore blanks.
A B C CountA
10 20 30 3
10 30 2
10 -20 30 3
10 1-Jan-88 30 3
10 21:30 30 3
BB 1 CC 3
354 #DIV/0! 487 3
21 1
a CC 2
COUNTBLANK
This function counts the number of blank cells in a range.
A B C CountBlank
10 20 30 0
10 30 1
10 -20 30 0
10 1-Jan-88 30 0
10 21:30 30 0
BB 1 CC 0
354 #DIV/0! 487 0
21 2
a CC 1
BACK TO INDEX
2
1 Use the Count function to calculate the following:
A B C D Count CountA CountBlank
4 -40 0:00 21 4 4 0
9 22-Mar-00 XL 2 3 1
5 ABC 96 41 3 4 0
2 #DIV/0! 51 2 3 1
6 #DIV/0! 32.000 61 3 4 0
23 984 75 71 4 4 0
7 0 12 81 4 4 0
This is the database of an HR Placement Agency, there are few Company names and
their HRs and their follow up status From this database count how many HRs have
not reverted back
HRs not reverted back 3
Company Name HR Status
Indiabulls Housing Finance Niharika G Bhardwaj Required
Larsen & Toubro Sanjoy K Roy Not Required
LIC Housing Finance Ranjit K Ramanujan Follow up
PNB Housing Finance Limited Anshul Bhargava
Housing Development Finance Corporation Praveen Kumar Bhalla Follow up
Bajaj Capital Sunaina Khanna
SBI Capital Markets india Leena Paulose
ICICI Bank Virendra Shilwant Required
Aditya Birla Group Tanvi Sondhi Not Required
DSP Merrill Lynch Limited Allan Lamb Follow up
Serial no. Mathematical Functions Syntax
1 COUNT COUNT(value1,value2,...)
2 COUNTA COUNTA(value1,value2,...)
3 COUNTBLANK COUNTBLANK(value1,value2,...)
Functions
Counts the number of numbers in supplied values.
Does not count empty cells.
Counts the number of empty cells in a range.
