Counting Poll Results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is there a way to total all answers in one column. For example, looking to
count all the answers that were "Yes" and all the answers that were "No"

Thank you
 
Possibly

=COUNTIF(A1:A20,"YES") & " Yes and " &COUNTIF(A1:A20,"No") & " No responses"

Mike
 
=COUNTIF(A:A,"Yes")

etc.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top