The formulas below show how the AREAS function can be configured. Notice the first example does not need an extra set of parentheses, since there is just one reference). However, the examples following do need the extra set of parentheses.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.