TRY SUB TOTAL

=SUBTOTAL(9,E4:E16)

R
PETE

--
(][ This Email has been scanned by Norton AntiVirus. ][)
"a_ndy2003_uk " wrote in
message ...
I need to use the SUM function to give a total for a set of data as
depicted by using Auto Filter.

Any ideas?

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




---
Message posted from http://www.ExcelForum.com/