Use Excel AREAS Function to check numbers of areas in a reference. In simple words, It will return that how many areas you have included in a reference.
In above example, I have referred to 3 cells and the function has returned 3 in the result.
reference A Reference to a cell or a range of cells.
More information on Excel AREAS Function
- If you want to refer to more than a one cell reference, you have to enclose all that references in more than one set of parentheses and use commas to separate each reference from other.
- Reference can be a cell, a range of cells or a named range.
In above example, I have used areas function to get the number reference in a named range.
To learn more about Excel AREAS Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.