Use COUNT with more than one range: =COUNT(A1:A12, B1:B12) : COUNT « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula:  =COUNT(A1:A12, B1:B12)
Input the formula:  =COUNT(A1:A12, B1:B12)
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)