Excel Function : AREAS

Download now!

Excel Function : AREAS

Category

Lookup and reference

Description

Returns the number of areas in a reference

Microsoft Excel Reference Page

https://support.office.com/en-us/article/AREAS-function-8392ba32-7a41-43b3-96b0-3695d2ec6152

Syntax and Description of the AREAS Excel Function

syntax AREAS function syntax AREAS function syntax Areas function syntax has the following arguments: Reference Required. A reference to a cell or a range of cells from which you want to count the number of areas. Areas Function Examples Example 1 Example 2 Example 3 Example 4 Example 5 Example 6 Example 7 Example 8 Example 9 Example 10 Example 11 Example 12 Example 13 Example 14 Example 15 #VALUE Error #VALUE Error is common in Microsoft Excel. It appears when a function, formula, or cell reference is not valid. To fix, try one

About AREAS Excel Function

The AREAS function returns the number of areas in a reference. An area is a range of contiguous cells. The reference must be a reference to a cell, a named range, or a table.