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
=SUM('1'!$D$2:$D$100000)/$B2