Thread: Calculations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CJ[_3_] CJ[_3_] is offline
external usenet poster
 
Posts: 4
Default 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