Some ways:
=SUMPRODUCT(--(E32:J32={E31,F31,G31,H31,I31,J31}))

or
=SUMPRODUCT(--(ISNUMBER(MATCH(E32:J32,E31:J31,0))))

--
Regards
Frank Kabel
Frankfurt, Germany

Paul wrote:
Hi Everyone,

Is there a Simplified Solution to this Formula Please :-

=COUNTIF(E32:J32,E31)+COUNTIF(E32:J32,F31)+COUNTIF (E32:J32,G31)+COUNTIF(
E32:J32,H31)+COUNTIF(E32:J32,I31)+COUNTIF(E32:J32, J31)

I have tried Several Alternatives but to NO avail.

Thanks in Advance
All the Best
Paul



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!