Returns the number of areas in a reference.
Syntaxis
AREAS(reference)Argumenten
referencevereist
A reference to a cell or range of cells.
The AREAS function counts the number of discrete ranges contained within a single reference. An area can be a single cell or a contiguous range of cells, and multiple areas are typically defined by separating them with commas inside parentheses.
=AREAS((A1:B2, D4:E5, F6))→3The reference contains three distinct areas separated by commas.
Select the cell
Click on the cell where you want to display the count of areas.
Enter the formula
Type =AREAS( followed by your reference enclosed in parentheses and press Enter.
No, AREAS counts the number of distinct ranges, not the number of cells within those ranges.