ExcelBanter - Summing filtered data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Summing filtered data (https://www.excelbanter.com/excel-worksheet-functions/167571-summing-filtered-data.html)

ismae

Summing filtered data

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?

Ron Coderre

Summing filtered data

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)

"ismae" wrote in message
...
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?

Flick Olmsford

Summing filtered data

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

"ismae" wrote:

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?

All times are GMT +1. The time now is 01:46 PM.