Something like

=SUMPRODUCT(SUBTOTAL(9,OFFSET($B$1,ROW($B$2:$B$20)-ROW($B$1),,1))*(C2:C20="N
o"))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Gustavo Strabeli" wrote in message
...
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 fruits.
It's like a subtotal function, however for the SUMIF.

Any chance to do it?

Thanks a lot,
Gustavo.