The =AREAS()
function is a built-in Microsoft Excel function that returns the number of areas in a reference. An “area” is a contiguous block of cells that share the same formatting or content. This function is useful for counting the number of distinct regions in a range of cells.
How to use =AREAS()
function in Excel:
To use the =AREAS()
function, simply enter “=AREAS(referance)
” into a cell. The “reference” argument can be any range of cells in the worksheet. The function will then return the number of distinct areas within that reference.
Example of =AREAS(reference)
function in excel formula:
- =AREAS(A1:D10) returns 1, as there is only one area within that range.
- =AREAS(A1:C5,F1:H5) returns 2, as there are two separate areas within the two ranges.
- =AREAS(A1:A5,B1:B5,C1:C5) returns 3, as there are three separate areas within the three columns.
- =AREAS(A1:A5,A6:A10,A11:A15) returns 3, as there are three separate areas within the three rows.
- =AREAS(A1:A10,B1:B10,C1:C10) returns 30, as each cell is its own area.
- =AREAS(A1:A5,A6:A10,A11:A15,A16:A20) returns 4, as there are four separate areas within the four rows.
- =AREAS(A1:B2,D1:E2,A3:B4,D3:E4) returns 4, as there are four separate areas within the four non-contiguous blocks of cells.
- =AREAS(A1:A10, A1:A10) returns 1, as the duplicated range is treated as a single area.
- =AREAS() returns an error because the function requires a range argument to work.
- =AREAS(A1:A1) returns 1, as a single cell is considered an area.
List of Similar Functions:
- COUNTIF: counts the number of cells within a range that meet a specified criterion.
- COUNTIFS: counts the number of cells within a range that meet multiple specified criteria.
- COUNT: counts the number of cells within a range that contain numbers.
- COUNTA: counts the number of cells within a range that are not empty.
- COUNTBLANK: counts the number of empty cells within a range.
FAQs for AREAS functions :
=AREAS()
function count hidden cells or ranges? No, the =AREAS()
function only counts visible cells and ranges.
AREAS()
function count non-adjacent ranges? Yes, the AREAS()
function can count non-adjacent ranges
An “area” is a contiguous block of cells that share the same formatting or content.
=AREAS()
function differ from the =Count()
function? The =AREAS()
function counts the number of distinct contiguous regions within a range, whereas the =Count()
function counts the number of cells within a range that contain numbers.
AREAS()
function count cells with formulas? Yes, the AREAS()
function counts cells with formulas if the formulas generate the same results across the cells.
Learn MS Excel Functions
- Real-World uses of Excel’s ATAN Function
- Comparing the Use of ATAN, ATAN2, and TAN Functions in Excel
- Mastering the ATAN Function in Excel: Tips and Tricks
- Mastering Excel: A Step-by-Step Guide on How to Filter Two Columns Using Advanced Filter Function
- Compare of ACCRINT & YIELD Functions – When to Use Each one
- Real-World Applications of Excel’s ACCRINT Function
- Mastering the ACCRINT Function in Excel: Tips and Tricks for Efficient Accrued Interest Calculations
- A Beginner’s Guide to AVERAGEIF Formula in Excel
- Learn VBA DIR Function – An Easy Explanation with Examples
- Learn =AVERAGEA() function – How to use with examples
- Learn =AVERAGE() function How to use with examples
- Learn =AVEDEV() Function – How to use with examples
- Learn =ATAN2() function – How to use with example
- Learn =ATAN() function – How to use with examples
- Learn =ASINH() function – How to use with Examples