View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gustavo Strabeli Gustavo Strabeli is offline
external usenet poster
 
Posts: 27
Default SUMIF with AutoFilter

Good Day to all!
Is there any possibility to use the SUMIF function along with AutoFilter?
I have the following situation:

Column A: Clients' names
Column B: Fruits
Column C: Quantities

When selecting, for example, a client name with the AutoFilter, I want SUMIF to give me the quantity of pineaples, for example.
It's like a subtotal function, however for the SUMIF.

Any chance to do it?

Thanks a lot,
Gustavo.