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

"Lerner" wrote:

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" wrote:

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.