How to use the AREAS Function in Excel

In this article, we will learn how to use AREAS Function in Excel. AREAS function is a reference function which returns the count of area references input as argument.

Cell or array References :

Perform the sum of numbers in A2 cell and A3 cell. See the below cell reference use.  Just click the cell after using equals to character (=). 

Excel helps you to differentiate between the 2 cell references with the different colour format as shown in the above snapshot. Now press Enter and you will have your result.

Learn more about absolute and relative cell references here.

AREAS function only takes references as input and returns the number of areas in references.

Syntax of AREAS function:

=AREAS(reference)

reference : a valid reference of the current worksheet.

Example:

All of these might be confusing to understand. So, let's test this formula via running it on the example shown below. Here we have some references to test the AREAS function in Excel.

Use the formula:

=AREAS((H4:H9,J8:J13,O11:O17,Q12:Q16))

These different colours shown above is the excel way of showing how many references are used. Press Enter to get the result.

There are 4 references as arguments to the AREAS function in excel. So the function returns 4 as result. Now try with a different number of cell or array references.

Here different number of references generates different result. You can also give reference from another sheet as shown E7 cell with formula and notes along with it.

Here are some observational notes using the AREAS function shown below.

Notes:

  1. The function only works with references.
  2. Reference argument a reference to a cell or range of cells and can refer to multiple areas.
  3. Use double brackets ( ( ref1, ref2,... ) ) when using multiple reference. Use a single bracket in case of only single argument
  4. The function doesn't even take input any datatype except reference.

Hope this article about How to use the AREAS function in Excel is explanatory. Find more articles on lookup & reference function formulas here. If you liked our blogs, share it with your fristarts on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write to us at info@exceltip.com.

Related Articles:

How to use the INDEX function in Excel : Find the INDEX of value in an array using the INDEX function explained with an example.

How to use the MATCH function in Excel : Find the MATCH in the array using the INDEX value inside MATCH function explained with example.

How to use OFFSET Function in Excel : experts know the power of the OFFSET function and how we can use this function to do some magical tasks in Excel formula. Here are the basics of the OFFSET function.

How to use LOOKUP function in Excel : Find the lookup value in the array using the LOOKUP function explained with example.

Use INDEX and MATCH to Lookup Value: The INDEX-MATCH formula is used to lookup dynamically and precisely a value in given table.  This is an alternative to the VLOOKUP function and it overcomes the shortcomings of the VLOOKUP function.

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity | Get faster at your task. These 50 shortcuts will make you work even faster on Excel.

The VLOOKUP Function in Excel | This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets. 

COUNTIF in Excel 2016 | Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.

How to Use SUMIF Function in Excel | This is another dashboard essential function. This helps you sum up values on specific conditions.

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube