HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: Areas Function

In Excel, the Areas function returns the number of ranges in a reference.

The syntax for the Areas function is:

Areas( reference )

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


Applies To:

  • Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

=Areas(A1) would return 1
=Areas(A1:C3) would return 1
=Areas((A1:C3, B4:B5)) would return 2
=Areas((A1:C3, B4:B5, G8)) would return 3
=Areas(suppliers) would return 3, if we defined a named range called suppliers as:
A1:C3, B4:B5, G8