Thread: Calculations
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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