Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

AREAS returns the number of areas in a reference

Input the formula: =AREAS(B2:D4). Press Enter to get the result.