LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Sum cells with variable number of rows

Hello,
Have a spreadsheet with 7000 rows, with a number of pieces in column G,
each having a Date in column A. Have used an IF worksheet function to
repeat the Date in column M of the last instance of each date. Need to Sum
the range of cells in column G that match the same date and place the result
in column N, beside the repeated Date. Can supply a 25 row snippet if need
it. Thanks for any help.
LSM


 
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
Copy cells to variable number of rows Acct Supr - DCTC Excel Discussion (Misc queries) 5 September 26th 09 12:58 PM
Summing a variable number of rows CEGavinMcGrath Excel Discussion (Misc queries) 4 August 28th 08 10:03 PM
change the number of rows to a variable theguz[_4_] Excel Programming 0 August 15th 05 09:55 PM
insert variable number of rows tina Excel Programming 1 February 9th 05 01:18 PM
Paste to variable number of rows brook6 Excel Programming 0 April 5th 04 09:36 PM


All times are GMT +1. The time now is 11:26 AM.

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"