Hi Jason,

Am Tue, 1 May 2012 06:25:53 +0000 schrieb Superjase14:

Site 1 52 89 84 89 Excellent
Site 2 52 52 Average
Site 3 18 58 52 Good

your values begin in A2, then try:
=CHOOSE(COUNT(B2:E2),"Poor","Average","Good","Exce llent")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2