Sum all rows above

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert - 07 May 2006 12:22 GMT

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

Reply to this Message

Ardus Petus - 07 May 2006 13:04 GMT

Hi Robert,

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

HTH
--
AP

>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

Reply to this Message

davesexcel - 07 May 2006 13:15 GMT

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

Signature

davesexcel

Reply to this Message

Ragdyer - 07 May 2006 18:14 GMT

Try this:

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

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> 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

Reply to this Message

Dave Peterson - 07 May 2006 18:43 GMT

One more.

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

> 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

Signature

Dave Peterson

Reply to this Message

Robert - 08 May 2006 11:44 GMT

Reply to this Message