Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count items in a filtered list?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Items in a List | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |