=COUNT(A2:A8,2) counts the number of cells that contain numbers in the list, and the value 2 : COUNT « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. COUNT
Input the formula: =COUNT(A2:A8,2). Press Enter to get the result.
Input the formula: =COUNT(A2:A8,2)
21.11.COUNT
21.11.1.COUNT(value1,value2,...) counts how many numbers are in the argumentsCOUNT(value1,value2,...) counts how many numbers are in the arguments
21.11.2.=COUNT(A2:A8,2) counts the number of cells that contain numbers in the list, and the value 2=COUNT(A2:A8,2) counts the number of cells that contain numbers in the list, and the value 2
21.11.3.Use COUNT with more than one range: =COUNT(A1:A12, B1:B12)Use COUNT with more than one range: =COUNT(A1:A12, B1:B12)