AREAS Formula - PK: An Excel Expert

Table of Contents

Definition:

The “AREAS” formula in Excel returns the number of areas in a reference. It is useful while working with non-contiguous ranges of cells or when combining ranges of different sizes.

Purpose:

The purpose of the “AREAS” formula is to count the number of individual ranges in a reference.

Syntax:

The syntax of the “AREAS” formula is

=AREAS(reference)

Parameters:

reference: Required. It specifies the reference for which you want to count the number of areas.

Returns:

The “AREAS” formula returns the number of areas in a reference.

Availability:

The “AREAS” formula is available in all versions of Excel.

Example-1:

=AREAS(A1:B2) returns 1, as it is a single range.

Example-2:

=AREAS((A1:A2, B1:B2)) returns 2, as it is two separate ranges.

Example-3:

=AREAS(A1:B2, C1:D2, E1:F2) returns 3, as it is three separate ranges.

Example-4:

=AREAS((A1:B2, C1:D2:E3)) returns 2, as it is two separate ranges.

Example-5:

=AREAS((A1:C1, A2:C2)) returns 2, as it is two separate ranges.

Tips and tricks:

Use the “AREAS” formula to quickly count the number of individual ranges in a reference.

Limitations:

The AREAS function only returns a numerical value representing the number of areas in a range. It does not provide any information about the individual areas.
The AREAS function is not commonly used in calculations and is more useful for reference purposes.

Common errors and solutions:

#VALUE! error: Occurs when the reference parameter is not a valid reference. Check the reference and ensure it is correct.

List of Related functions:

COUNT: Returns the number of cells in a range that contains numbers.
COUNTA: Returns the number of non-empty cells in a range.
COUNTBLANK: Returns the number of blank cells in a range.

Frequently Used with the formulas:

The “AREAS” formula is frequently used with other formulas like “SUM” or “AVERAGE” to perform calculations on individual ranges within a larger reference.