“COUNT” and “COUNTA” Function in Excel

Lesson
Materials

 

The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. Values can be supplied as constants, cell references, or ranges.

The syntax for the COUNT function is

=COUNT (value1, [value2], …)

The arguments as defined as below:

  • value1 – An item, cell reference, or range.
  • value2 – [optional] An item, cell reference, or range.

In the example, we want to count to total number of records we have. These records are the total number of students that too the examination with their total scores and result.

We can sue the COUNT function to achieve that.

Use =COUNT(D2:D8). The result should be 7.

Note that the COUNT function does not count Empty cells. All numbers including negative values, percentages, dates, fractions, and time are counted. Empty cells and text values are ignored.

 

Please Note the below:

  • COUNT can handle up to 255 arguments.
  • COUNT ignores the logical values TRUE and FALSE.
  • COUNT ignores text values and empty cells.

 

The COUNTA:

This function returns the count of cells that contain numbers, text, logical values, error values, and empty text (“”). COUNTA does not count empty cells.

The syntax include:

=COUNTA (value1, [value2], …)

The arguments are as below:

  • value1 – An item, cell reference, or range.
  • value2 – [optional] An item, cell reference, or range.

Remember to download the working file from the materials tab and use it while practicing.

 

 

Download the below file for this lesson on COUNT and COUNTA.

count_counta.xlsx