In other words, you want to count how many times apple is displayed in column
E?

Try this:

=SUBTOTAL(3,E2:E4545)

--
Biff
Microsoft Excel MVP


"Lerner" wrote:

=subtotal(9,f2:f4545)
This formula works for totaling ( SUMMING) column F after filtering the items
I need. F are amounts.
In column E, I have items ( apples, oranges, lemons).
I'm in need of a formula that, after doing the dropdown on the top column
(filtering), lets say apple, I'll get the subtotal of apples.
The same racionality of the given formula above, but directed to counting not
to SUM.
Thanks.