AREAS

AREAS(reference)

Returns the number of areas in a cell range or reference.

reference

The reference to a range of cells.

REMARKS

* This function cannot be used to help identify cell ranges that have been populated with data.
* An area is a range of contiguous cells or a single cell.
* The "reference" can refer to multiple cell ranges.
* The "reference" can be a named range or several cell references.
* If you want to specify several references as a single argument, then you must include an extra sets of parentheses. (Rows 4 and 5)
* For the Microsoft documentation refer to support.microsoft.com

	A	B	C
1	=AREAS(B1) = 1	2	5
2	=AREAS(B1:C1) = 1	4	10
3	=AREAS(B1:C6) = 1	6	15
4	=AREAS((B1:B3,B5:B6)) = 2
5	=AREAS((B1:B3,C1:C3)) = 2	8	20
6	=AREAS((B1:B3,C5:C6)) = 2	10	25
7	=AREAS((B1:C5,B1:B2,C3:C5)) = 3
8	=AREAS((B1,C2,B3,C5,B6)) = 5
9	=AREAS(B1:B2 B1) = 1
10	=AREAS(B1 B2 B3) = #NULL!

1 - How many areas are in the range "B1".
2 - How many areas are in the range "B1:C1".
3 - How many areas are in the range "B1:C6"
4 - How many areas are in the range "B1:B3,B5:B6".
5 - How many areas are in the range "B1:B3,C1:C3".
6 - How many areas are in the range "B1:B3,C5:C6".
7 - How many areas are in the range "B1:C5,B1:B2,C3:C5".
8 - How many areas are in the range "B1,C2,B3,C5,B6".
9 - How many areas are in the range "B1:B2 B1".
10 - How many areas are in the range "B1 B2 B3".