Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

To specify several references as a single argument, include extra sets of parentheses

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