how do you put the subtotal of the sum and count in one spreadhseet?
B Bob Phillips Feb 1, 2006 #2 Use the SUBTOTAL function. =SUBTOTAL(3,A1:A100) and =SUBTOTAL(9,A1:A100) -- HTH Bob Phillips (remove nothere from email address if mailing direct)
Use the SUBTOTAL function. =SUBTOTAL(3,A1:A100) and =SUBTOTAL(9,A1:A100) -- HTH Bob Phillips (remove nothere from email address if mailing direct)
