LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default count each row for total matches

I have data from a survey( 49 questions) from 484 subjects. They had to
choose 7 questions. Each subject responses are entered in a row ( 484 rows)
as a number (from 1 to 49) each subject has 7 responses (7 cells) (7
columns). I want to select a group of questions at a time and see how many
subjects answered those questions. for example if i choose #3, 7,11,22,33 and
60 of my subjects match 3 or 4 of my numbers then at the end of the row i
want a total of how many matched ie 3 or 4.
 
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
How do you count data that matches more than one condition? ryesworld Excel Worksheet Functions 9 March 23rd 09 02:41 AM
Compare columns, count matches adodson Excel Worksheet Functions 19 January 25th 07 02:34 AM
count the # of entries when sum matches the target [email protected] Excel Worksheet Functions 4 February 15th 06 01:01 AM
How do I count number of cels the matches 2 conditions ? Abra Excel Worksheet Functions 2 February 27th 05 08:56 PM
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. witchcat98 Excel Worksheet Functions 1 February 4th 05 01:38 PM


All times are GMT +1. The time now is 02:18 PM.

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

About Us

"It's about Microsoft Excel"