=COUNTA(A1:A7,2) counts the number of nonblank cells in the list above and the value 2 : COUNTA « Statistical functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Statistical functions
3. COUNTA

Input the formula: =COUNTA(A1:A7,2). Press Enter to get the result.

21.12.COUNTA
	21.12.1.	COUNTA(value1,value2,...) counts how many values are in the list of arguments
	21.12.2.	=COUNTA(A1:A7,2) counts the number of nonblank cells in the list above and the value 2
	21.12.3.	=COUNTA(A1:A7,"Item") counts the number of nonblank cells in the list above and the value "Item"
	21.12.4.	Use the COUNTA function to return the number of nonblank cells in a range named Data