Sum and Indirect

[u0107]

Hello all,

Please look at the following 5 cell contents.

A1 --- 'Daily Execution Tracker'!$Z$61
A2 --- 'Daily Execution Tracker'!$F$61
A3 --- 'Daily Execution Tracker'!$F$61:'Daily Execution Tracker'!$Z$61
A4 --- 44
A5 --- 0

In the tab 'Daily Execution Tracker' on z61, I have the value of 44.
In the tab 'Daily Execution Tracker' on f61, I have the value of 0.
The formula in A3 above is Concatenate(A1,":",A2)
The formula in A4 is Indirect(A1)
The formula in A5 is Indirect(A2)

I would like the Sum of the range as specified in cell A3 in another cell on my spreadsheet.

Can anyone help with the Sum formula?

I get an error if I use Sum(Indirect(A3)).

Thanks in advance.

Uttam

 

[Aladin Akyurek]

Try...

=SUM(INDEX('Daily Execution Tracker'!$F$61,1,1):INDEX('Daily Execution Tracker'!$Z$61,1,1))

 

[u0107]

Works - Thank you very much!

Uttam