Hi,
Have looked there, however I can't use SUMIF with SUBTOTAL.
Any other clue?


"Arvi Laanemets" escreveu na mensagem ...
Hi

Look at worksheet function SUBTOTTAL in Excel Help


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



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