Hi All,
As a recent new member this is my first post to the forum.
I am looking for a formula that will calculate a result based on whether all items meet a certain criteria.
Attached is the file which has a more detailed description of what I require along with the table of data.
Appreciate any help,
Thanks,
Adrian 
Hi Adrian
See if this is what you want.
Sunny
Hi
a first attempt
in F5:
=IF(COUNTIF(D$5:D5,D5)>1,"",IF(COUNTIFS(D:D,D5,E:E,"Pass")=COUNTIF(D:D,D5),"Yippee!",IF(COUNTIFS(D:D,D5,E:E,"Fail")=COUNTIF(D:D,D5),"Oh no!","")))
Regards
-----
Edit: sorry SunnyKow, I did not mean to overlap.
Hi Canapone
No problem. All are welcome to help. We can learn form each other.
Hi Adrian
Refer another option.
Hi Sunny,
Have applied your formula and this has worked ok.
Thanks,
Adrian 
