View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hmmmmm? Hmmmmm? is offline
external usenet poster
 
Posts: 3
Default 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