Excel has no built-in way to accomplish that.
My commercial add-in "Special Print" can do it with a work around.
You can download the free trial and use the Rows to Repeat at Bottom utility.
You will need to enter subtotal formula(s) using R1C1 type references in
the repeating row. The formula(s) must be entered without the equal sign.
You replace the equal sign(s) after the sheet you print from is created.
If you have questions I can provide guidance.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Minx"
wrote in message
Is there a way to give me sheet subtotals at print time?

I have a spreadsheet with rows and rows of calculations. I do not set hard
page breaks because the number of rows varies as the project moves along. Is
there any way that I can get the subtotal of various columns for each page
printed? Kind of like a header, except with summation?