Excel AREAS Function

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

  1. Click on an empty cell (like F5 ).
an empty cell in excel

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

 the fx icon in excel

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

 insert function tab in excel

4. Select Lookup & reference category.

5. Select AREAS function.

6. Then select ok.

excel AREAS function

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.

How to use AREAS function in excel

Examples of AREAS function in excel

Examples of AREAS function in excel

AREAS related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *