Hi All,

Having a little problem getting this indirect to work.

=SUM(INDIRECT("RC[37]:RC["&VALUE((37+5+(F87/2)))&"]",FALSE))

Where I am aiming to sum the current Row from column 37 to column 44.
The Second column number needs to come from a calculation - in the above
example: VALUE((37+5+(F87/2))) - Which = 44.

Any suggestions?

Cheers.
Bam.