Auto Filter?

M

Mario

HOw do I add a colum on numbers for a group of rows that
have been grouped by auto filter. When I sum the colum
it gives me the sum from row 1-333 not
rows ,5,6,9,11,56,11,331.
 
K

Ken Wright

Use the SUBTOTAL function, eg:-

=SUBTOTAL(9,A1:A333)

The 9 is the SUM argument, as you can have count, average etc as well.
 
Top