Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default how can I use excel to tabulate survey results

Can I use Excel to tabulate survey results, using some sort of counter to
track totals? Thanks.
--
Maiadd
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how can I use excel to tabulate survey results


Can you be more specific in what you mean by that.

If for example it's a survey with multiple choice answers (i.e. A, B,
C, D, and E) and Questions (1-10). Assume that question numbers are in
column A, Answers in B, you could use a sumproduct to get the total
number of Answer "A" for Question 3 like so

=SUMPRODUCT(--($A$1:$A$100=3),--($B$1:$B$100="A"))

You could also add in more information as if you wanted to tabulate
based on other peices of data, such as age, sex, etc. But in all
reality an example would be easier to help with this.


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=567143

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
Writing macro results to user defined areas within excel gauss1976 Excel Discussion (Misc queries) 1 July 27th 06 01:35 PM
Excel file with hyperlinks takes a long time to open over the network Didier P Links and Linking in Excel 3 July 4th 06 04:39 PM
how do i set results to appear in status bar of excel okhameed Excel Discussion (Misc queries) 2 August 29th 05 11:29 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Pivot Table for survey results with set of possible answers in PT's Rows Field? [email protected] Excel Discussion (Misc queries) 0 May 16th 05 10:35 PM


All times are GMT +1. The time now is 03:50 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"