subtotal of sum and count in one spreadhseet?
 

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

subtotal of 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?