Auto Filter?

[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.

 

[Peo Sjoblom]

Try

=SUBTOTAL(9,Range)

 

[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.