ExcelBanter - Counting Poll Results

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting Poll Results (https://www.excelbanter.com/excel-worksheet-functions/163959-counting-poll-results.html)

nabanco

Counting Poll Results

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

Mike H

Counting Poll Results

Possibly

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

Mike

"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

Bob Phillips

Counting Poll Results

=COUNTIF(A:A,"Yes")

etc.

--
---
HTH

Bob

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

"nabanco" wrote in message
...
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

JE McGimpsey

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

All times are GMT +1. The time now is 02:18 AM.