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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hidden rows problem 7
How do I autosum a filtered column 1
Referncing Rows of Filtered Data 8
Sum of filtered data 3
Sum after Filter, Count after Fliter 2
Excel 2007 Autofilter vs Excel 2003 2
No difference between SUM and SUBTOTAL (9) 1
Summing Filtered Rows 4

Top