Scribd
Upload
38 views2 pages

Count Function in Excel

Uploaded by

mr.sakshamthakur18
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
38 views2 pages

Count Function in Excel

Uploaded by

mr.sakshamthakur18
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1.

COUNT function

The COUNT function is used to count the number of cells containing


a number. Always remember one thing that it will only count the
number.
Formula for COUNT function = COUNT(value1, [value2], …)

Example of statistical function.

Thus, there are 7 textbooks that have a discount out of 9 books.

2. COUNTA function

This function will count everything, it will count the number of the
cell containing any kind of information, including numbers, error
values, empty text.
Formula for COUNTA function = COUNTA(value1, [value2], …)
Example of statistical function.

So, there are a total of 9 subjects that being sold in the store

3. COUNTBLANK function

COUNTBLANK function, as the term, suggest it will only count blank


or empty cells.
Formula for COUNTBlANK function = COUNTBLANK(range)

Example of statistical function.

There are 2 subjects that don’t have any discount.

You might also like