Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Extract all partial matches in Excel
  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Create hyperlink with VLOOKUP in Excel
  • How to use Excel COLUMN Function
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • How to Create Column Chart in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • How to create Checklist in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Understanding Pivot Tables in Excel

Data Validation Examples

  • Excel Data validation no punctuation
  • Excel Data validation specific characters only
  • Excel Data validation date in specific year
  • Excel Data validation whole percentage only
  • Excel Data validation number multiple 100

How to use Excel AREAS Function

by

This Excel tutorial explains how to use the AREAS function with syntax and examples.

Excel AREAS function Description

The Microsoft Excel AREAS function returns the number of ranges in a reference.

The AREAS function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function in Excel. As a worksheet function, the AREAS function can be entered as part of a formula in a cell of a worksheet.

Explanation: The Excel AREAS function returns the number of areas in a given reference. For example, =AREAS((A1:C1,A2:C2)) returns 2. Multiple references must be enclosed in an extra set of parentheses.

=AREAS((A1:C1)) // returns 1
=AREAS((A1:C1,A2:C2)) // returns 2
=AREAS((F17:F19,J16:J18,I8)) // returns 3

Syntax

The syntax for the AREAS function in Microsoft Excel is:

AREAS( reference )

Returns

The AREAS function returns a numeric value.

Post navigation

Previous Post:

How to use Excel ADDRESS Function

Next Post:

How to use Excel CHOOSE Function

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Split text and numbers in Excel
  • Extract most frequently occurring text in Excel
  • How to strip html from text or numbers in Excel
  • How to count specific words in a cell in Excel
  • CONCATENATE function: Description, Usage, Syntax, Examples and Explanation
  • Add months to date in Excel
  • Display Days until expiration date in Excel
  • Get days, hours, and minutes between dates in Excel
  • Get work hours between dates custom schedule in Excel
  • Next biweekly payday from date in Excel
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • Calculate payment periods for loan in Excel
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles