Forum Discussion
Solved
Trying to figure out to run one calculation across multiple sheets
Hello, I have an excel file set up where the first page is a series of calculations and tables related to information on the proceeding pages. Basically I am trying to run a formula that looks like...
Got It!
The formula works like
=(SUM(INDIRECT("'"&A2&"'!"&"$G$3:$G$10000"))/B2)
This will save me countless hours and errors.
Hi,
Try this =SUM('1'!$D$2:$D$100000)/$B2
- Hello,
Thank you for the quick reply! That takes care of the row shifts in D2-D10000, but the sheet number still stays on 1 unfortunately.Hi,
Remove '1' in the formula. Coz, =SUM('1'!$D$2:$D$100000)/$B2 will work only for sheet named as 1.
Put formula as =SUM($D$2:$D$100000)/$B2 which will work on any sheet.
Got It!
The formula works like
=(SUM(INDIRECT("'"&A2&"'!"&"$G$3:$G$10000"))/B2)
This will save me countless hours and errors.