MS Excel: AREAS Function (WS)

This Excel tutorial explains how to use the Excel AREAS function with syntax and examples.


The Microsoft Excel AREAS function returns the number of ranges in a reference.


The syntax for the Microsoft Excel AREAS function is:

AREAS( reference )

Parameters or Arguments

reference is a range of cells. If you specify more than one range, you must surround your ranges with brackets.

Applies To

The AREAS function can be used in the following versions of Microsoft Excel:

  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The AREAS function can be used in Microsoft Excel as the following type of function:

  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel AREAS function examples and explore how to use the AREAS function as a worksheet function in Microsoft Excel:

Result: 1

Result: 1

Result: 2

Result: 3

Result: 3   (if we defined 
a named range called suppliers as: 
A1:C3, B4:B5, G8)