Functions Count() and Counta()

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.

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.