| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting cells in two columns that have the same results | Excel Worksheet Functions | |||
| Should I generally request "post a poll" when I post a new thread? | Excel Discussion (Misc queries) | |||
| counting results of a list | Excel Worksheet Functions | |||
Hybrid Mode
