| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a filtered list | Excel Discussion (Misc queries) | |||
| Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
| Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
| Using ONLY the data filtered | Excel Discussion (Misc queries) | |||
| summing values appearing in col B when col A has been filtered | Excel Worksheet Functions | |||
Linear Mode
