| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF COUNTIF - Need Help with multiple criteria
Bob,
Thank you! Thank you! -- Mary "Bob Phillips" wrote: Try this Mary =IF(NOT(COUNTIF(D83:S83,"X")),"Y",IF(L83="X","P"," N")) HTH Bob "Hmmmmm?" wrote in message ... Let me explain what I am trying to do. I have a row of cells D83:S83 on a form which identify work constraints. When information is filled out (by others) it is with an X. What I am trying to do in cell T83 is identify if work can proceed or not ( with the IF function - N=true or Y=false). If any cells have an "X", work cannot proceed. I am using conditional formatting to turn the cell red for True and green for False. However...and this is where it gets tricky, if cell L83 has an "X" it needs to be flagged differerently, but I am not sure how to do this. I tried breaking the function out like so =IF(COUNTIF(D83:K83,"=X")+COUNTIF(M83:S83,"=X"),"N ","Y") which works to eliminate the data in L83, but now I don't know how to add this criteria in so that the formula will work. If L83 has an "X" I would like cell T83 to reflect a "P" rather than a "Y" or "N". I don't know if this is even possible. Thank you --- Mary "Bob Phillips" wrote: Looks like the wrong function. When you say selected, what do you mean? It looks like you might just want =IF(L83="X","P","N") HTH Bob "Hmmmmm?" wrote in message ... I am trying to get this to work =IF(COUNTIF(D83:S83,"=X"),"N","Y"),+IF(COUNTIF(L83 ,"=X"),"N","P") so that if L83 is selected the result in the cell would be P. Perhaps I am using the wrong function. Ideas anyone? Thank you. -- Mary . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif with multiple criteria | Excel Discussion (Misc queries) | |||
| Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
| COUNTIF() with multiple criteria | Excel Discussion (Misc queries) | |||
| Multiple Criteria using countif | Excel Worksheet Functions | |||
| multiple criteria in a countif | Excel Programming | |||
Hybrid Mode
