That seems like that would work, but when I run my macros and remove a
product the SubTotal does not calculate automatically. How do I get it to do
that?

"Harlan Grove" wrote:

RyanH wrote...
I wish I could, but each product description can be 5-15 rows long.
When I print the worksheet, it may be 1 to 5 pages long. So I
really need a movable SubTotal cell.
....

OK, you have other calculations below this subtotal cell. This
subtotal cell already exists in your worksheet, no? If so, you'd want
to sum the values in this column from row 6 to the row above this
formula cell. It seems the complication is that you may need to insert
(or delete?) rows as the number of items or the number of rows needed
for their descriptions varies. If so, use a blank row between the last
row of item or description data and the subtotal row. For example, if
the initial layout had item lines in rows 6 to 35, leave row 36 blank
and enter the subtotal formula in row 37 as

=SUM(F$6:F36)

Insert/delete rows below row 6 and above row 36, and this formula will
adjust automatically. This is an ancient spreadsheet technique.