# COUNT

## 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.

### COUNTIFS

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

### 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.

### 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.

### 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).

### 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).

### 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.