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.