I didn't correct the F87 and it still worked for me (also xl2003).

I don't have a guess why it didn't work for you, but I do have a guess why it
worked for me (and should have worked for you).

Excel seems to translate A1 reference style into R1C1 reference style after the
formula is entered. Then displays based on the choice in Tools|options.

Create a workbook with 2 sheets (sheet1 and sheet2)
format A1 in Sheet1 as General
Format A1 in Sheet2 as Text

Group the sheets, but have Sheet1 the activesheet.
enter the formula in A1 (of sheet1)

Look at the string that's returned in A1 of Sheet2.
=SUM(INDIRECT("RC[37]:RC["&(42+(R[86]C[5]/2))&"]",FALSE))

Kind of interesting, huh?


Max wrote:

Dave,

I couldn't get my xl2003 (set to R1C1 style) to accept this
=SUM(INDIRECT("RC[37]:RC["&(42+(F87/2))&"]",FALSE))
It returned: #NAME?

But I could get this up:
=SUM(INDIRECT("RC[37]:RC["&42+(R87C6/2)&"]",FALSE))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---

--

Dave Peterson