Forum Discussion
Solved
#REF error in formula in first copied sheet.
Hello and thank you. I have a workbook with the following formula =SUM('1:Goals'!I3)/(SHEETS()-1) The formula is in a sheet named "1" and there is another sheet after it named "Goals" When I co...
Create an empty sheet before '1', and name it (for example) Dummy.
Use =SUM('Dummy:Goals'!I3)/(SHEETS()-2)
Copying the '1' sheet should not cause #REF! now.
Create an empty sheet before '1', and name it (for example) Dummy.
Use =SUM('Dummy:Goals'!I3)/(SHEETS()-2)
Copying the '1' sheet should not cause #REF! now.
- Thank you, this works.
