What exactly is the problem? - I return a #REF! Error - Except if "F87" = 0.

I guess I don't need to use R1C1 referencing - I just couldn't figure out
how else to do it!

Column F Contains a number from 0 - 26.

My Data i want to sum always starts at column 37 ($AL).

I need to add 5 columns + # of Columns of "F" / 2.

Or - As in this eg: =SUM(INDIRECT("RC[37]:RC["&(42+(F87/2))&"]",FALSE))

Use the number 42 (37 + 5) and add column F divided by 2 .

I'm happy to take another path though?

Thanks for your help.


"T. Valko" wrote:

Having a little problem getting this indirect to work.

What exactly is the problem?

I am aiming to sum the current Row from column 37 to column 44.
=SUM(INDIRECT("RC[37]:RC["&VALUE((37+5+(F87/2)))&"]",FALSE))

The columns referenced are *relative* to where the formula is entered. Do
you need to use R1C1 referencing? It confuses a lot of people!


--
Biff
Microsoft Excel MVP


"Bam" wrote in message
...
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.