IF COUNTIF - Need Help with multiple criteria
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
|