View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default tallying survey results

=COUNTIF(A:A,"Yes")
=COUNTIF(A:A,"No")
--
David Biddulph

"marcietmp" wrote in message
...
I am doing a spreadsheet where I am tallying yes/no responses of a survey.
What formula can I use that would be easiest to make a "check" for each
yes
and no response, giving the total?