LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
By-Tor
 
Posts: n/a
Default How can you sum the last 5 columns of data from a range of data

I have a range of data that ranges from a3 to g43. Some of the range is empty
of data but I enter new data daily. So say the data is currently entered
through row 15. Is there a way I can sum just the last 5 rows of entered
data and have it update automatically whenever I add in a new row of data
into the already established range? Hope that is clear enough.
 
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
Dynamic Data Range dallin Excel Worksheet Functions 4 November 21st 05 07:21 PM
Select updated data from a range of columns Alylia Excel Worksheet Functions 5 August 30th 05 01:53 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Data range properties baz Excel Discussion (Misc queries) 1 April 1st 05 09:37 AM
data range properties baz Excel Discussion (Misc queries) 0 April 1st 05 08:53 AM


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

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

About Us

"It's about Microsoft Excel"