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
--
AP

"Robert" <[email protected]> a écrit dans le message de news:
[email protected]...
>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
>

[davesexcel]

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

[Ragdyer]

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Robert" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[Dave Peterson]

One more.

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

Robert wrote:
>
> 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

--

Dave Peterson

[Robert]

"Robert" <[email protected]> wrote in message
news:[email protected]...
>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
>