I recommend fiddling with Pivot Tables / Pivot Reports. This will do the
sum, group, grandtotal that you're after.


"RJH" wrote in message
...
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