Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 7th 06, 12:22 PM posted to microsoft.public.excel.newusers
Robert
 
Posts: n/a
Default Sum all rows above

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



  #2   Report Post  
Old May 7th 06, 01:04 PM posted to microsoft.public.excel.newusers
Ardus Petus
 
Posts: n/a
Default Sum all rows above

Hi Robert,

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

HTH
--
AP

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



  #3   Report Post  
Old May 7th 06, 01:15 PM posted to microsoft.public.excel.newusers
davesexcel
 
Posts: n/a
Default Sum all rows above


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


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539632

  #4   Report Post  
Old May 7th 06, 06:14 PM posted to microsoft.public.excel.newusers
Ragdyer
 
Posts: n/a
Default Sum all rows above

Try this:

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

--
HTH,

RD

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



  #5   Report Post  
Old May 7th 06, 06:43 PM posted to microsoft.public.excel.newusers
Dave Peterson
 
Posts: n/a
Default Sum all rows above

One more.

If your formula is in A101:
=sum(a1ffset(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


  #6   Report Post  
Old May 8th 06, 11:44 AM posted to microsoft.public.excel.newusers
Robert
 
Posts: n/a
Default Thanks to all who posted


"Robert" wrote in message
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rows & Columns in Excel seadragon69 Excel Worksheet Functions 2 December 7th 05 06:54 PM
Automatically inserting rows ausdiver99 Excel Worksheet Functions 1 June 2nd 05 02:15 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM
Insert rows Mr. G. Excel Worksheet Functions 3 March 31st 05 03:49 AM
flexible paste rows function that inserts the right number of rows marika1981 Excel Discussion (Misc queries) 1 February 18th 05 03:40 AM


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017