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 at
another worksheet, here it must look for all entries in January for
example.
When it has found these entries i need it to count the number of
'passes' that occur in row 4 of a sheet. I have tried using DSUM but am
not completely sure how to use it in this scenario.

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

Thanks in advance


--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=529614

I don't get:

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


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=529614

I need the formulae:

To look at the drop down box, if this = January for example i need it
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 january
entries and count the number of pass values.....


--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=529614

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 the
DDM choice? Or is this all just what formula to use?


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=529614

Ok, possibly to help you more understand my problem more i have attached
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 |
+-------------------------------------------------------------------+

--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=529614

looking now ...


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=529614

I am not familiar with the type of DDM you have. I inserted one that I
am familiar with and know how to configure. It seems like the only
hold up is how to identify which columns to look at when counting
passes and fails. I just don't have the time to do it for you but now
at least I can speak to the issues you encounter. Take a look and let
me know if you are seeing anything that is new and helpful with this
task. Note that you can right click on the DDM and choose options for
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 |
+-------------------------------------------------------------------+

--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=529614

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

Cheers


--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile: http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=529614

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

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

take care


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=529614