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