Use the COUNTA function to return the number of nonblank cells in a range named Data : COUNTA « Statistical functions « Microsoft Office Excel 2007 Tutorial





Name A1:C4 as Data. Input the formula: =COUNTA(Data)
Input the formula: =COUNTA(Data)










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