# 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".