In this article, we will learn about how to use the SHEETS function in Excel.
SHEETS function in excel is built-in reference function. This function returns a number, reference to input sheet indicated. SHEETS function can be used for following purposes in Excel.
The SHEETS function is a cell reference function. SHEETS function in excel returns a number, referring the input sheet value
Let’s understand this function using it in an example.
We will get to learn all the uses of the function. So we get through it on by one.
Here in the above snapshot, The function returns 6 as output as there are total 6 worksheets in the worksheet. The result of the formula in under Result column and Its formula in the adjacent column.
See the above snapshot to view its application, Result & formula.
Here a range of sheets are provided Sheet2:Sheet5. In the range there are 4 sheets. So the function returns 2 as output.
For the above result, we defined a table named range “box” as called its reference using the SHEETS function in the worksheet.
Here are some of the observational results about thr function.
Hope you understood how to use SHEETS function and referring cell in Excel. Explore more articles on Excel function here. Please feel free to state your query or feedback for the above article.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.