Calculations
 

If I enter this into a cell:

=COUNTIF(E5:K5,"P")

If there is a P then it counts the cell. So if all of the
cells, E5-K5 have a P then the total will be 7.

I want it to look for P, T, or L. How can I get one cell
to search for all 3 of those?

I've tried many things and I am all tried out. Any help
would be great. Thanks.

CJ

Calculations
 

Hi
try:
=SUM(COUNTIF(E5:K5,{"P","T","L"}))

--
Regards
Frank Kabel
Frankfurt, Germany


CJ wrote:
If I enter this into a cell:

=COUNTIF(E5:K5,"P")

If there is a P then it counts the cell. So if all of the
cells, E5-K5 have a P then the total will be 7.

I want it to look for P, T, or L. How can I get one cell
to search for all 3 of those?

I've tried many things and I am all tried out. Any help
would be great. Thanks.

CJ

Calculations
 

You're a genius. Thank you my good man.

CJ

-----Original Message-----
Hi
try:
=SUM(COUNTIF(E5:K5,{"P","T","L"}))

--
Regards
Frank Kabel
Frankfurt, Germany


CJ wrote:
If I enter this into a cell:

=COUNTIF(E5:K5,"P")

If there is a P then it counts the cell. So if all of
the
cells, E5-K5 have a P then the total will be 7.

I want it to look for P, T, or L. How can I get one
cell
to search for all 3 of those?

I've tried many things and I am all tried out. Any help
would be great. Thanks.

CJ
.