Count()

This function is used to count the number of cells which contain numeric values. It does not count the cells that are empty or contain any alpha-numeric data.

Syntax:

= Count (Cell1, Cell2, Range1,....)

*Cell1, Cell2, Range1 = Cells/Ranges for which the count is to be calculated*

Example:

For the above image, various usages of Count() function will give the following results:

- =Count(B1:B6) - result will be - 5 {cell B1 is not counted}
- =Count(B2:B6) - result will be - 5 {all cells in the range are numeric}
- =Count(A1:B6) - result will be - 5 {cells with text are ignored}
- =Count(A1:B8) - result will be - 6 {blank cells are also ignored}
- =Count(B1,B2) - result will be - 1

Counta()

Similar to Count(), the function Counta() is ised to count the number of cells, but with this function you can count the number of cells that contain alpha-numeric data, i.e. - cells that contain numbers and alphabets (any text).

Syntax:

= Count (Cell1, Cell2, Range1,....)

Cell1, Cell2, Range1 = Cells/Ranges for which the count is to be calculated

Example:

For the above image, various usages of Count() function will give the following results:

- =Counta(B1:B6) - result will be - 6
- =Counta(B2:B6) - result will be - 5
- =Counta(A1:B6) - result will be - 12
- =Counta(A1:B8) - result will be - 14
- =Counta(B1,B2) - result will be - 2

The counta() function also ignores the blank cells from the total count.

## 0 comments:

## Post a Comment