chuckdanger
New Member
- Joined
- Apr 27, 2015
- Messages
- 7
Hello,
So I am looking to create an equation that will add multiple pages together based on a pre-selected range by user. My first thought was since all the data on each tab is not used, i would set up an Indirect equation to set get only the necessary data.
I have this so far :
=SUM(INDIRECT("'"&$B$1&"'!"&I$1&$A10)&":"&INDIRECT("'"&$B$2&"'!"&I$1&$A10))
where:
B1 = start tab
B2 = end tab
I = column reference
A= row reference
How can I adjust to make Totals page work dynamically?
So I am looking to create an equation that will add multiple pages together based on a pre-selected range by user. My first thought was since all the data on each tab is not used, i would set up an Indirect equation to set get only the necessary data.
I have this so far :
=SUM(INDIRECT("'"&$B$1&"'!"&I$1&$A10)&":"&INDIRECT("'"&$B$2&"'!"&I$1&$A10))
where:
B1 = start tab
B2 = end tab
I = column reference
A= row reference
How can I adjust to make Totals page work dynamically?
