How can I count items in a filtered list?
the 2nd column B3:B50 has a drop down option
Assuming that means you have AutoFilter applied...
Try these:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B3:B50,ROW(B3:B50)-ROW(B3),0,1)),--(B3:B50="NET
- TNBA Callbacks"))
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B3:B50,ROW(B3:B50)-ROW(B3),0,1)),--(B3:B50="NRA
- Montreal EMT"))
--
Biff
Microsoft Excel MVP
"kosageinusha18" wrote in message
...
Hi just a noob here,
I would like to know how or what function do I need to use on this kind of
problem. I am creating a template where the 2nd column B3:B50 has a drop
down
option, so I'd like that Column to be counted examples on the drop down
are .
NET - TNBA Callbacks and NRA - Montreal EMT.
Ex. if B2:B50 have (10) . NET - TNBA Callbacks it will appear (10) on J15
and if NRA - Montreal EMT have (3) it must appear (3) on J16.
hope that helps in explaining...its too hard to explain, I am wishing if I
could attach the file for better view..
thanks again.. waiting for your response
|