Thread: Summing filtered data
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Flick Olmsford Flick Olmsford is offline
external usenet poster
  
Posts: 46
Default 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 With QuoteReply With Quote