Sum all rows above

[Robert]

I want to put into a cell the total of all numbers above that cell in that
column. I want to do this without specifying specific rows. In this way,
if a row were added above the total, it would be included in the total
correctly.

Robert

 

[Ardus Petus]

Hi Robert,

Try:
=SUM(OFFSET(A1,,,ROW()-1,1))

HTH

 

[davesexcel]

=sum(indirect("r1c"&column()&":r"& (row()-1)&"c"&column(),false))

 

[Ragdyer]

Try this:

=SUM(INDIRECT("A1:A" & ROW()-1))

 

[Dave Peterson]

One more.

If your formula is in A101:
=sum(a1ffset(a101,-1,0))

 

[Robert]

I want to put into a cell the total of all numbers above that cell in that
column. I want to do this without specifying specific rows. In this way,
if a row were added above the total, it would be included in the total
correctly.

Robert