Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

COUNTA(value1,value2, ) counts how many values are in the list of arguments

=COUNTA(A2:A8) counts the number of nonblank cells in the list above Input the formula: =COUNTA(A2:A8). Press Enter to get the result.