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