Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Then Calculations | Excel Worksheet Functions | |||
Calculations | Excel Discussion (Misc queries) | |||
! in Calculations | Excel Discussion (Misc queries) | |||
Calculations | Excel Worksheet Functions | |||
Between calculations | Excel Worksheet Functions |