What is AREAS Function in Excel?
The AREAS function is one of the (Lookup & reference) functions of Excel.
It Returns the number of areas in a reference.
An area is a range of contiguous cells or a single cell.
We can find this function in Lookup & reference category of insert function Tab.
How to use AREAS function in excel
- Click on an empty cell (like F5 ).

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.

4. Select Lookup & reference category.
5. Select AREAS function.
6. Then select ok.

7. In the function arguments Tab, you will see AREAS function.
8. Reference section is a reference to a cell or range of cells and can refer to multiple areas.
9. You will see the result in the formula result section.

Examples of AREAS function in excel

AREAS related functions
- CHOOSE function
- INDIRECT function
- COLUMNS function