COUNT(value1,value2,...) counts how many numbers are in the arguments : COUNT « Statistical functions « Microsoft Office Excel 2007 Tutorial





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










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)