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