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!

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!

Thanks Frank,

I could NOT get the First One to Work, But the Second One Works Great.

Thanks Again.
All the Best
Paul


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

Hi
first one depends on your regional settings. Try replacing the coma within
the curly brackets with
..
or
/

--
Regards
Frank Kabel
Frankfurt, Germany
"Paul" schrieb im Newsbeitrag
...
Thanks Frank,

I could NOT get the First One to Work, But the Second One Works Great.

Thanks Again.
All the Best
Paul


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

Hi Frank,

Thanks for the Reply.
I Tried :-
..
,
..
;
:
/
But to No Avail.
Not to Worry though as I am Using the Second One which Works Great and
Accomodates my Needs.
Thanks for the Solution.

Have a Great New Year.
All the Best
Paul



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