=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






Input the formula: =COUNTA(A1:A7,2). Press Enter to get the result.
Input the formula: =COUNTA(A1:A7,2)
21.12.COUNTA
21.12.1.COUNTA(value1,value2,...) counts how many values are in the list of argumentsCOUNTA(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=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"=COUNTA(A1:A7,
21.12.4.Use the COUNTA function to return the number of nonblank cells in a range named DataUse the COUNTA function to return the number of nonblank cells in a range named Data