Hello,
I want to sum a range built by two separate addresses (that will change based on user input), I have the formulas to return the correct address but cant seem to get a sum without an error.
Address 1: =ADDRESS(4,MATCH(WaterFalls!C4,'Calcs&fixed data for plots'!A2:BE2,0)) => $E$4
Address 2: =ADDRESS(4,MATCH(WaterFalls!C5,'Calcs&fixed data for plots'!A2:BE2,0)) => $G$4
How would I get to =SUM($E$4:$G:$4)
I also will want to get to =AVERAGE($E$4:$G:$4)
I want to sum a range built by two separate addresses (that will change based on user input), I have the formulas to return the correct address but cant seem to get a sum without an error.
Address 1: =ADDRESS(4,MATCH(WaterFalls!C4,'Calcs&fixed data for plots'!A2:BE2,0)) => $E$4
Address 2: =ADDRESS(4,MATCH(WaterFalls!C5,'Calcs&fixed data for plots'!A2:BE2,0)) => $G$4
How would I get to =SUM($E$4:$G:$4)
I also will want to get to =AVERAGE($E$4:$G:$4)