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.
|