Formulas / AREAS
Calculate the number of areas in a reference.
  • reference - required cell or range of cells


  • =AREAS(A1:C1)

    This function allows you to count the number of references in a range, and returns 1 because there is only one reference.

  • =AREAS((A1:C1,A2:C2))

    You can also use this function to count multiple references in a range. For example, This formula returns 2 because there are two references.

  • =AREAS((F17:F19,J16:J18,I8))

    This function also works with a range of non-contiguous cells. For example, This formula returns 3 because there are three references.


The AREAS function counts the number of areas in a reference. An area is a single cell or a range of contiguous cells. When inputting multiple references, extra parentheses must be used to prevent Sourcetable from interpreting the comma as a field separator.

  • The AREAS function takes one argument, called reference, which can be used to reference more than one range.
  • When using multiple references, the AREAS function requires extra parentheses.

Frequently Asked Questions

What is the AREAS function?
The AREAS function returns how many areas a reference contains.
What type of argument does the AREAS function require?
The AREAS function takes a reference argument. The reference argument is a cell or range of cells.
Can the AREAS function take multiple references?
Yes, the AREAS function can take multiple references in one argument. However, multiple references need to be included in extra sets of parentheses. Sourcetable will interpret the comma as a field separator if multiple references are not included in extra sets of parentheses.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.