Summing filtered data

I

ismae

Hi everyone! I'm looking for some function that lets me sum data filtered by
the AutoFilter (like the SUM function but one that ignores the data not shown
by the filter). Any clues?
 
R

Ron Coderre

The SUBTOTAL function does what you want (and a lot more).
See that topic in Excel help.

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
F

Flick Olmsford

Might either the SUMIF function or the Data | Subtotals command work instead?
 
Top