Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

Use the COUNTA function to return the number of nonblank cells in a range named Data

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