Summing filtered data

  • Thread starter Thread starter ismae
  • Start date Start date
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?
 
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)
 

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
Sum a column of filtered data 1
Sum after Filter, Count after Fliter 2
Auto-filter with Sum product? 2
How do I autosum a filtered column 1
No difference between SUM and SUBTOTAL (9) 1
Sum of filtered data 3
Sumproduct with autofilter 1

Back
Top