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.
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.