| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tallying survey results
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tallying survey results
You are a little thin on details but in general you can use these formulas
CountIf, SumProduct or you could use a pivot table. Without more info it is hard to comment on which might be most appropriate. What does your data look like? -- HTH... Jim Thomlinson "marcietmp" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Survey Results help | Excel Worksheet Functions | |||
| Averaging survey results | Excel Worksheet Functions | |||
| survey results | Excel Worksheet Functions | |||
| survey results tally | Excel Worksheet Functions | |||
| Tabulating Survey Results | Excel Discussion (Misc queries) | |||
Linear Mode
