Statistical Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Statistical Functions
  4. COUNTA(value1,value2, ) counts how many values are in the list of arguments
=COUNTA(A2:A8) counts the number of nonblank cells in the list above

Input the formula: =COUNTA(A2:A8). Press Enter to get the result.