.. give me an answer in R1C1 style?

Guess I'm not sure why you're apparently blind to Dave's & my responses in
the other branch of your post

How about this then, as posted earlier:
=SUM(INDIRECT("RC[37]:RC["&42+(R87C6/2)&"]",FALSE))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800, Files:359, Subscribers:56
xdemechanik
---