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