IF COUNTIF - Need Help with multiple criteria

  • Thread starter Thread starter Hmmmmm?
  • Start date Start date
H

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.
 
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
 
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
 
Back
Top