ExcelFlux

AREAS function

the number of areas in a reference.

Lookup and reference · Guided Excel example

Where can you use it?

Reporting and operations teams. Use functions in this group to retrieve a field from an item, employee or order list, select the right record, or move values into another report.

Scenario in the workbook

A contiguous reference is one area. Ctrl-select another disjoint range to compare the area count.

A worked example from the workbook

RowA
6Input
710
820
930
Record 1
=AREAS(A7:A9)

Illustrative output1

See the inputs and instructions for all 3 examples

Syntax

AREAS(reference)

Copyable formulas

English Excel · en-US
=AREAS(A2:D8)
Turkish Excel · tr-TR
=ALANSAY(A2:D8)

Expected result

1

Worked examples

A contiguous reference is one area. Ctrl-select another disjoint range to compare the area count.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 10
8 20
9 30
Trial Expression Sample output
Record 1 =AREAS(A7:A9) 1
Record 2 =AREAS(A7:A9) 1
Record 3 =AREAS(A7:A9) 1
Microsoft Excel reference