=Sum (Auto Filter)
 

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

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

=Sum (Auto Filter)
 

Use
=SUBTOTAL(9,range)
instead.

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

:confused:


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

=Sum (Auto Filter)
 

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.

:confused:


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