how do you put the subtotal of the sum and count in one spreadhseet?

Use the SUBTOTAL function.

=SUBTOTAL(3,A1:A100)

and

=SUBTOTAL(9,A1:A100)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SM" wrote in message
...
how do you put the subtotal of the sum and count in one spreadhseet?