Sum After Segmented Number Series in Column

Gary · Feb 22nd, 2002, 09:54 AM

Hello,

I hope someone can help me or point me in the right direction. I have a file that has three blank rows between each different storeroom number. I need to add totals to the second (middle) blank cell after every segmented number series under QTY, PRICE, and TOTAL; however, I need to have the flexibility to be able to pick a starting cell in any column, not just column B, C, and D (this is just one file we would use this for).

STORE
ROOM.....QTY......PRICE......TOTAL
005-29........1........33.00......33.00

Need total>...1........33.00.....33.00

005-2921......1........73.64.....73.64
005-2921......1........73.64.....73.64
005-2921......1........73.64.....73.64

Need total>...3.......220.92....220.92

020-1065......2.........4.06......8.12
020-1065......6.........4.06.....24.36

Need total>...8.........8.06.....32.48

Is there a macro that would do this? I've searched, but did not find one. I appreciate any assistance, thanks.

[ This Message was edited by: Gary on 2002-02-22 09:56 ]

[ This Message was edited by: Gary on 2002-02-22 09:59 ]

[ This Message was edited by: Gary on 2002-02-22 10:01 ]

Anne Troy · Feb 23rd, 2002, 10:01 AM

Hi!

You will want to post your question in the correct forum. This is where people can test their signatures and things like that. Click on the link:

http://www.mrexcel.com/board/viewforum.php?forum=2&1830

and post your question there. Just copy/paste it. Then, I'll take a look and many others will too!

Welcome to MrExcel!

Feb 23rd, 2002, 10:01 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,535	Hi! You will want to post your question in the correct forum. This is where people can test their signatures and things like that. Click on the link: http://www.mrexcel.com/board/viewforum.php?forum=2&1830 and post your question there. Just copy/paste it. Then, I'll take a look and many others will too! Welcome to MrExcel! __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 09:54 AM	#1
Gary New Member Join Date: Feb 2002 Location: Paducah, KY Posts: 3	Hello, I hope someone can help me or point me in the right direction. I have a file that has three blank rows between each different storeroom number. I need to add totals to the second (middle) blank cell after every segmented number series under QTY, PRICE, and TOTAL; however, I need to have the flexibility to be able to pick a starting cell in any column, not just column B, C, and D (this is just one file we would use this for). STORE ROOM.....QTY......PRICE......TOTAL 005-29........1........33.00......33.00 Need total>...1........33.00.....33.00 005-2921......1........73.64.....73.64 005-2921......1........73.64.....73.64 005-2921......1........73.64.....73.64 Need total>...3.......220.92....220.92 020-1065......2.........4.06......8.12 020-1065......6.........4.06.....24.36 Need total>...8.........8.06.....32.48 Is there a macro that would do this? I've searched, but did not find one. I appreciate any assistance, thanks. [ This Message was edited by: Gary on 2002-02-22 09:56 ] [ This Message was edited by: Gary on 2002-02-22 09:59 ] [ This Message was edited by: Gary on 2002-02-22 10:01 ]