Scribd
Upload
123 views2 pages

All Count Functions

The document explains four Excel functions: COUNT, COUNTA, COUNTBLANK, and COUNTIF. COUNT counts numeric entries in a specified range, COUNTA counts all non-empty cells, COUNTBLANK counts empty cells, and COUNTIF counts cells that meet a specific criterion. Examples are provided for each function to illustrate their usage.

Uploaded by

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

All Count Functions

The document explains four Excel functions: COUNT, COUNTA, COUNTBLANK, and COUNTIF. COUNT counts numeric entries in a specified range, COUNTA counts all non-empty cells, COUNTBLANK counts empty cells, and COUNTIF counts cells that meet a specific criterion. Examples are provided for each function to illustrate their usage.

Uploaded by

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

COUNT function:

The COUNT function counts the number of cells that contain numbers, and counts numbers
within the list of arguments. Use the COUNT function to get the number of entries in a number
field that is in a range or array of numbers. For example, you can enter the following formula to
count the numbers in the range [Link] =COUNT(A1:A20). In this example, if five of the cells in
the range contain numbers, the result is 5.

COUNTA function:
The COUNTA function counts cells containing any type of information, including error values
and empty text (""). For example, if the range contains a formula that returns an empty string,
the COUNTA function counts that value. The COUNTA function does not count empty cells.

COUNTBLANK function:
Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty
cells in a range of cells.

Syntax

COUNTBLANK (range)

The COUNTBLANK function syntax has the following arguments:

Range Required. The range from which you want to count the blank cells.

COUNTIF function:
COUNTIF function

Applies To

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a
criterion; for example, to count the number of times a particular city appears in a customer
list.

In its simplest form, COUNTIF says:

▪ =COUNTIF (Where do you want to look? What do you want to look for?)
For example:

▪ =COUNTIF(A2:A5,"London")

▪ =COUNTIF(A2:A5,A4)

You might also like