I am a little confued on how the data is layed out on the
sheet. Could you give us a small example?

-----Original 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


.