IF COUNTIF - Need Help with multiple criteria

[Hmmmmm?]

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.

 

[Bob Phillips]

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?]

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

 

[Bob Phillips]

Try this Mary

=IF(NOT(COUNTIF(D83:S83,"X")),"Y",IF(L83="X","P","N"))

HTH

Bob

 

[Hmmmmm?]

Bob,
Thank you! Thank you!
--
Mary

Try this Mary

=IF(NOT(COUNTIF(D83:S83,"X")),"Y",IF(L83="X","P","N"))

HTH

Bob




.