Count, Counta, Countblank, Formula in MS Excel

Count, Counta, Countblank, Formula

The following are different count formulas in MS Excel:

1. COUNT: Returns the number of cells in a range that contain numbers.

Syntax: COUNT(value1, [value2, ...])

Example: =COUNT(A1:A10)

This formula counts the number of cells in the range A1 to A10 that contain numbers.

2. COUNTIF: Returns the number of cells in a range that meet a specified condition.

Syntax: COUNTIF(range, criteria)

Example: =COUNTIF(A1:A10,">10")

This formula counts the number of cells in the range A1 to A10 that contain values greater than 10.

3. COUNTBLANK: Returns the number of empty cells in a range.

Syntax: COUNTBLANK(range)

Example: =COUNTBLANK(A1:A10)

This formula counts the number of empty cells in the range A1 to A10.

4. COUNTIFS: Returns the number of cells in multiple ranges that meet multiple conditions.

Syntax: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2, ...])

Example: =COUNTIFS(A1:A10,">10",B1:B10,"<20")

This formula counts the number of cells in the range A1 to A10 that contain values greater than 10, and the number of cells in the range B1 to B10 that contain values less than 20.

5. COUNTIFS: Returns the number of cells in a range that contain non-blank values.

Syntax: COUNTIFS(range)

Example: =COUNTA(A1:A10)

This formula counts the number of cells in the range A1 to A10 that contain non-blank values.