Hi,

Maybe it 's the way some people use Excel.
If you would just leave all orders togheter, no blanks.
A simple sort on order number and add a subtotal (Menu Data/Subtotal ...)
and Voila.
Because we don't get a proper course (or get a book), we don't use certain
software as we should.
Formatting Data is the End report thing.
Regards,

Jean-Yves Tfelt

"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