Thread: How do I create a survey using excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Curtis Dave Curtis is offline
external usenet poster
  
Posts: 100
Default How do I create a survey using excel?
Hi,

Do you want something as simple as a bar chart displaying the total number
of "yes" and "no"?

Assuming your responsex are in B1:B20,

use =COUNTIF(B1:B20,"Yes")

and =COUNTIF(B1:B20, "No")

to give you each total. Plot these as a bar chart.

Dave

url:http://www.ureader.com/msg/10356312.aspx
Reply With QuoteReply With Quote