=Sum (Auto Filter)

[a_ndy2003_uk]

I need to use the SUM function to give a total for a set of data a
depicted by using Auto Filter.

Any ideas?

At the moment I just seem to be SUM'ing the entire column, it wont le
me just total whats in view.

:confused

 

[Stephen Bye]

Use
=SUBTOTAL(9,range)
instead.

 

[OZDOC1050]

TRY SUB TOTAL

=SUBTOTAL(9,E4:E16)

R
PETE