Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Survey Results help Curt1521 Excel Worksheet Functions 1 December 19th 06 12:16 AM
Averaging survey results jmstut Excel Worksheet Functions 1 December 6th 06 05:59 PM
survey results [email protected] Excel Worksheet Functions 1 December 6th 06 12:21 AM
survey results tally ME Hill Excel Worksheet Functions 3 May 30th 06 07:37 PM
Tabulating Survey Results Tabulatin Survey results Excel Discussion (Misc queries) 3 December 13th 04 10:56 PM


All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"