summing a range where the starting point varies each time

[trina2000]

I'm creating a spreadsheet that has several different buildings with a varying numbers of rows per building. The number of buildings will also vary from project to project.

for each building there will be x rows. I can insert the number of rows below each building which is X however, I don't know how to go to the top cell of the new column to be summed.

I'm trying to use the formula below to do so.

ActiveCell.Offset(0, 3).FormulaR1C1 = "=SUM(RXC:R[-1]C)"

regards

 

[lbass]

You are in the wrong forum--this is a forum for Crystal Reports. If you are working with Excel, try the Microsoft Office forum.

-LB

 

[trina2000]

thanks!