COUNT

Counts cells with only Numbers in Excel
Counts how many numbers are in the list of arguments

Rational

Counts cells with only Numbers.

Description

The Excel COUNT function compute the count of numbers within the reference list of arguments ignoring the text and blank cells.
For example, if A1:A10 contain five numeric value and remaining cells are empty or text to count numerical value in the range A1:A10: =COUNT(A1:A10) will return 5 (only numeric rest ignored).

Syntax

= COUNT(value1, [value2], …)

Parameters

value1 – First range or array of numbers
value2 [optional] – Second range or array of numbers.
The COUNT function can accommodate up to 255 numbers as an argument.

Return Value

An Integer indicating counts of cells with numbers.

Key Notes

  • The COUNT function counts the number of numerical (positive or negative) including dates values in each range (value)
  • The user can use the COUNTA function to include text value as well.
  • Logical values (TRUE and FALSE), Text or blank cells are ignored. Error value like #DIV/0! are not counted.

 

Keep Reading Similar Functions:

Counts cells that are not blank in Excel

COUNTA

The COUNTA function count of numbers and text within the reference list of arguments ignoring blank cells, =COUNTA(A1:A10) will return 7 (disregard blank).

Read More »
Count reference cells based on criteria in Excel

COUNTIF

The COUNTIF function returns a count of number based on given criteria like =COUNTIF(A1:A5,”>5″) that count numbers in the list >5 and returns 3.

Read More »
Count cells that are blank in Excel

COUNTBLANK

The COUNTBLANK function returns the count of blank cells only ignoring number and text cells Like,=COUNTBLANK(A1:A10) will return 3 (ignoring value).

Read More »
Count reference cells based on multiple criteria in Excel

COUNTIFS

The COUNTIFS function returns a count of numbers based on one or multiple given criterion based on dates, numbers, and text.

Read More »
To add multiple numbers in Excel

SUM

The SUM function returns a number after adding multiple numeric arguments together =SUM(5,10,15) the Excel add numbers together and returns 30.

Read More »
Find the average of numbers in Excel

AVERAGE

The AVERAGE function returns an average of numbers positioned in one or multiple ranges, =AVERAGE(5,15,30) add numbers and divide by 3, and returns 16.67.

Read More »