=AREAS(reference)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single AREAS formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
reference:
The reference to a range of cells or an array for which you want to count the number of areas. This can include multiple ranges that are not contiguous.
The AREAS function in Excel is a useful tool that returns the number of areas in a reference. An area is defined as a continuous range of cells, and the AREAS function helps you identify how many distinct areas are present in a given reference.
In simpler terms, the AREAS function allows you to determine the count of separate ranges in your data, which can be particularly helpful when working with complex datasets.
Imagine you are working with a dataset that contains multiple ranges of data in an Excel spreadsheet:
| Salesperson | Sales Amount | Region |
|---|---|---|
| Alice | 200 | East |
| Bob | 150 | West |
| Charlie | 300 | East |
| David | 250 | West |
| Eve | 100 | East |
In this case, you want to find out how many distinct areas are present in a selection that includes both the sales data and some empty cells.
To calculate the number of areas in a reference, you would use the AREAS formula as follows:
=AREAS(A1:C6)When you apply the formula, it counts the number of distinct areas in the specified range. If the range includes only one continuous area, the output would be:
| Number of Areas |
|---|
| 1 |
If you had multiple non-contiguous ranges, the output would reflect the total number of those distinct areas.
The AREAS function is particularly useful when you need to analyze data that may be spread across multiple ranges. It helps you understand the structure of your data and can be beneficial in scenarios where you need to reference or manipulate specific areas of your dataset.
Understanding how to use the AREAS function can enhance your data management capabilities in Excel, enabling you to better navigate and analyze your datasets.
Happy calculating!
You have a workbook with multiple worksheets, each representing a different department within your company. You can use the AREAS function to determine the number of areas (or ranges) in a reference that includes all the department sheets. This helps in quickly assessing how many distinct data ranges you are working with across departments, allowing for better organization and management of data without the need for manual counting or complex formulas.
Beyond the AREAS function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.