COUNT « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. COUNT
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)