ok, guess I'm slow, but not sure exactly what you mean. Could you give me
more instruction?

"SAM SEBAIHI" wrote:



used it with filter
=SUBTOTAL(9,B2:B13)

then copy it down,

use
=SUBTOTAL(1,B2:B13) for average
=SUBTOTAL(3,B2:B13) for count
=SUBTOTAL(9,B2:B13) for sum


--------------------------------------------------------------------------------
Sam Sebaihi Faculty Western International University Associate Programs
(alternate email) Phone #:
(405)315-8223 Time zone: Pacific Time
"Amethyst" wrote in message
...
I need to know how to create subtotals for individual pages in excel. The
user has data each month consisting of hundereds of rows. Is it possible
to
have excel total a specific column at each page break in addition to the
grand total at the end of the sheet? If this requires a progamming fix, i
will need someone to help me with the code as I have a little experience
but
I'm still learning.