Drop Down FIlters.

P

PaulOakley

Hi I have a complex question.

I need:

A drop down box with the months Jan- December (i have this sorted)

I need this drop down box and whatever month is in it to look a
another worksheet, here it must look for all entries in January fo
example.
When it has found these entries i need it to count the number o
'passes' that occur in row 4 of a sheet. I have tried using DSUM but a
not completely sure how to use it in this scenario.

I have no idea how to combat this problem and hope i have explaine
above.

Thanks in advanc
 
W

William DeLeo

I don't get:

"When it has found these entries i need it to count the number o
'passes' that occur in row 4 of a sheet.
 
P

PaulOakley

I need the formulae:

To look at the drop down box, if this = January for example i need i
to look at a quantity of data which will include many other months.

The formulae will then need to count the number of values that occur.
These values are limited to 'Pass' and 'Fail'.

Therefore e.g if the month is january it will look at all januar
entries and count the number of pass values....
 
W

William DeLeo

I can take a closer look if someone more adept doesn't chime in first
but does part of your issue relate to how to pull information from th
DDM choice? Or is this all just what formula to use
 
P

PaulOakley

Ok, possibly to help you more understand my problem more i have attache
an annotated zip file xls.

Thanks in advance, having a nightmare with this system build

+-------------------------------------------------------------------
|Filename: HELP!.zip
|Download: http://www.excelforum.com/attachment.php?postid=4580
+-------------------------------------------------------------------
 
W

William DeLeo

I am not familiar with the type of DDM you have. I inserted one that
am familiar with and know how to configure. It seems like the onl
hold up is how to identify which columns to look at when countin
passes and fails. I just don't have the time to do it for you but no
at least I can speak to the issues you encounter. Take a look and le
me know if you are seeing anything that is new and helpful with thi
task. Note that you can right click on the DDM and choose options fo
it (such as which cell to link the choice to ... see "calculations
sheet I added)

+-------------------------------------------------------------------
|Filename: HELP_deleo.zip
|Download: http://www.excelforum.com/attachment.php?postid=4581
+-------------------------------------------------------------------
 
P

PaulOakley

Thanks for your help that makes far more sense!!
Have become so involved in it that all the logic seems to have bee
lost.

Cheer
 
W

William DeLeo

that happens ... I am glad I could help. I try to glance at the othe
posts when I post a question ... take a little of the burden off th
gurus ... give and take.

Let me know if you have any other questions ... now if I can only ge
MY question answered ;)

take car
 
Top