Counting Subtotal
 

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

Counting Subtotal
 

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.

Counting Subtotal
 

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.

Counting Subtotal
 

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

--
Biff
Microsoft Excel MVP


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

Counting Subtotal
 

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.