Auto Filter?

  • Thread starter Thread starter Mario
  • Start date Start date
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.
 
Use the SUBTOTAL function, eg:-

=SUBTOTAL(9,A1:A333)

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