Can this Formula be Shortened Please

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" <[email protected]> schrieb im Newsbeitrag
news:%[email protected]...
> 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!