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