How to use Excel COUNT Function


COUNT function in excel is a statistical function. This function is used to count the number of values that are numbers; usually these are the cells that contain numbers. This is a worksheet function and can be entered into the cell in which count is required.


=COUNT(value1, value2, …., …)


Value1:   1st range of values or reference to a cell

Value2:   2nd range of values or reference to a cell


  • COUNT function can use up to 255 additional values.
  • Text values, logical values, empty cells are not used for counting and omitted.
  • If one wants to count text values and logical values, use COUNTA function.
  • COUNTIF and COUNTIFS function are used if one wants to use certain criteria for counting.


In this example, various values are entered in Column A and Column B, and  COUNT function is used to count  values of Column A and column B using the formula =COUNT(A4:A9, B4:B9) which gives 12 as the result.

1 thought on “How to use Excel COUNT Function”

  1. Pingback: How to use Excel COUNTBLANK Function - Excelhub

Leave a Comment

Your email address will not be published. Required fields are marked *