View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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