Your formula worked ok for me.

But so did this slightly simplifed version:
=SUM(INDIRECT("RC[37]:RC["&(42+(F87/2))&"]",FALSE))

If you really meant column 37 (not the 37th column to the right):
=SUM(INDIRECT("RC37:RC["&(42+(F87/2))&"]",FALSE))

And if you really meant column 44 (not 44th column to the right):
=SUM(INDIRECT("RC37:RC"&(42+(F87/2)),FALSE))

Those [] brackets tell excel to offset that number of rows/columns from the cell
with the formula.

If this doesn't help, you may want to explain what the problem is.

Bam wrote:

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.

--

Dave Peterson