LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
RJH RJH is offline
external usenet poster
 
Posts: 44
Default Summing undetermined colums

Hello,
You guys helped me with a problem a week or so ago. Your solution worked
great!
Here's another, if you don't mind.

My stockroom guy is using Excel to track orders. He lists his orders
horizontally across the row and grouped by order number.
He may have 1, 2, or many lines in a order. He leaves one blank row to
differentiate between groups of orders. We have a formula giving him the
total price of each line and he uses autosum to get a total of the column of
totals in a full order. Although the autosum feature is great, is there a
way to automate his full order total. I believe it would involve finding
the blank row above the order to determine to so called "top"and summing all
the lines below that.

Thanks for any ideas!

RJH


 
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
Summing 2 columns cells into a 3rd colums cells Wayne Cadigan Excel Discussion (Misc queries) 1 May 13th 10 08:34 PM
Summing values from an undetermined number of sheet smaruzzi Excel Worksheet Functions 3 April 6th 07 08:16 PM
PivotTable and summing/not summing ~*Amanda*~[_2_] Excel Discussion (Misc queries) 1 March 14th 07 07:35 PM
Colums Retsel Charts and Charting in Excel 1 September 1st 05 11:42 AM
Sum YTD Colums Mestrella31 Excel Discussion (Misc queries) 1 January 11th 05 05:13 PM


All times are GMT +1. The time now is 06:00 AM.

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

About Us

"It's about Microsoft Excel"