How to Use Excel SHEETS Function

    how to use excel sheets function

    Quick Intro

    By using Excel SHEETS Function you can get the number of sheets in a reference. In simple words, it will return the number of sheets used in a reference.

    Definition of Excel SHEETS Function

    In above example, I have referred to cell A1 in the same sheet & SHEETS Function returned with 1 as only 1 sheet is in reference.

    Syntax

    SHEETS(reference)

    • reference Reference for which you want to count numbers of sheets.

    More Information on SHEETS Function

    • It will include all type of sheet (Chart Sheet, Worksheet or Macro Sheet).
    • You can refer to sheets even they are visible, hidden or very hidden.
    • If you skip specifying any value in the function it will give you the count of total sheets in a workbook
    • If you specify an invalid reference, it will return a #REF!.

    Examples

    In the below example, we have used 3D cell reference to get the sum of cell A1 from five sheets. And, I have used the same reference to get the count of sheets.

    Examples To Understand Excel SHEETS Function

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel SHEETS 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.There is also you have

    There is also you have SHEET function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.