AREAS(ref)
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ref} is a reference to a cell or range of cells and can refer to multiple areas.
Description
- It gives the number of areas in a reference.
- It should be surrounded with brackets, if there is more than one range.
- The area can be single cell or many continuous cells
Let's see an example =AREAS(B3:D5) is 2 =AREAS((B3:D5,E7,F5:I3)) is 3
Examples
See Also
References
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | ||||
| Row2 | 7 | 2 | ||
| Row3 | ||||
| Row4 | 10000 | |||
| Row5 | ||||
| Row6 |