View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Counting Poll Results

One way:

=COUNTIF(A:A,"Yes")

=COUNTIF(A:A,"No")

In article ,
nabanco wrote:

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