Excel indirect address question

[Prunus]

Hi
A really basic Excel question:
I have a complicated sheet with a lot of data and calculations. A function extracts from the data a position where certain rules are fulfilled. The output of the function is in first cell the address where these rules were OK first time and in second cell the address where the rules were OK last time. For example output could be B4 in 1st cell and B10 in 2nd cell. The outputs are text strings.
Now I need to use this information in other function, like sum the area between these cells like =SUM(B4:B10). So how can I import the original text strings “B4” and “B10”) into a function so that the function is able to really calculate b4+B5+...+B10.

Thank you in advance

 

[mrgoldthorpe]

If cells C1...C6 contains the addresses (B4, B10...etc.) then it's

=SUM(INDIRECT(C1):INDIRECT(C6))

 

[Prunus]

Thank you very, very much mrgoldthorpe. I had made an elementary mistake in my calculations as I had wrote =SUM(INDIRECT(C1:C6)) which was not obviously working.