Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing 2 columns cells into a 3rd colums cells | Excel Discussion (Misc queries) | |||
Summing values from an undetermined number of sheet | Excel Worksheet Functions | |||
PivotTable and summing/not summing | Excel Discussion (Misc queries) | |||
Colums | Charts and Charting in Excel | |||
Sum YTD Colums | Excel Discussion (Misc queries) |