Easy Explanation Notes with Examples

AREAS function in Excel

Use

The AREAS function returns the number of areas in a reference. For example, =AREAS((A2:C3,B5:C7)) returns 2 areas.

Syntax

AREAS(reference)

The function has the following argument:

Reference – Required. A reference to a cell or a range of cells or a named range. For more than one references, an extra set of parentheses needed in the formula.

Example

The following spreadsheet shows three simple examples of the AREAS function.

For more detail and examples, visit Microsoft office website.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved