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
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
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
>
=sum(indirect("r1c"&column()&":r"& (row()-1)&"c"&column(),false))
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
>
>
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" <[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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks