AREAS
Returns the number of areas in a reference.
- Excel: Verified match
- Google Sheets: No equivalent
- Returns: Number
Examples
=AREAS(A1:C5) | A | B | C | |
|---|---|---|---|
| 1 | 10 | 2 | alpha |
| 2 | 20 | 4 | beta |
| 3 | 30 | 6 | gamma |
| 4 | 40 | 8 | delta |
| 5 | 50 | 10 | epsilon |
Result 1
Syntax
AREAS(reference)reference- range required
Related
ADDRESSReturns a cell address as text from row and column numbers. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string. LOOKUPLooks up value in one-row or one-column range.