close
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)
quot;SMquot; gt; wrote in message
...
gt; how do you put the subtotal of the sum and count in one spreadhseet?
全站熱搜
留言列表
