View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default formula to count number of two different non-numeric responses

=countif(range,"Yes")+countif(range,"NA")

Regards,
Fred

"cookie's mom" wrote in message
...
having trouble with this - need help on what formula to count the total of
two different non-numeric values in a range, i.e., "Yes" and "NA" - trying
COUNTIF, but having trouble...