Thread: Adding sum of "yes"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default Adding sum of "yes"
=COUNTIF(A2:A500,"yes")

--


Regards,


Peo Sjoblom

"JohnR" wrote in message
...
I have a survey with a number of "yes" "no" questions and trying to simply
add the number of "Yes" in a column. Any ideas?



Reply With QuoteReply With Quote