View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kelie Kelie is offline
external usenet poster
 
Posts: 2
Default How to add only the adding filtered result using SUM function?

Hello,

I have a column with some numbers and they're added up at the bottom
of the column with the SUM function. Now when I use a filter on
another column, some rows become hidden, but the sum does not change.
In this case, I'd like to just add those visible rows.

Thanks for your help!