Question

how is sheet reference used in a function? (excel) no spam please​

Answer 1

Answer:

The SHEETS function counts all the sheets in a reference, ... new SHEET and SHEETS functions in Excel 2013

Answer 2

Answer:

The INDIRECT function returns a reference to a range. You can use this function to create a reference that won't change if row or columns are inserted in the worksheet. Or, use it to create a reference from letters and numbers in other cells.

hope it will help u