Counting Subtotal

[Lerner]

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

 

[T. Valko]

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

Try this:

=SUBTOTAL(3,E2:E4545)

 

[Lerner]

Yes, this is exactly what I was looking for.
Now, the formula for' counting' is the same as the one for 'suming' except
for number '3' and number '9', if it is not much trouble and you or someone
knows the answer: what's the racionality of those numbers(3 and 9)in those
two formulas.
Thanks T. Valko.

 

[T. Valko]

The SUBTOTAL function can perform a variety of calculations. Look in Excel
help for SUBTOTAL to see what those calculations are.

 

[Alojz]

As Biff indicated, 3 and 9 are different parameters of Subtotal formula, 9
makes sum, 3 makes count.