Can this Formula be Shortened Please

[Paul]

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

 

[Frank Kabel]

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

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

 

[Paul]

Thanks Frank,

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

Thanks Again.
All the Best
Paul

 

[Frank Kabel]

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

 

[Paul]

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