Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you count data that matches more than one condition? | Excel Worksheet Functions | |||
Compare columns, count matches | Excel Worksheet Functions | |||
count the # of entries when sum matches the target | Excel Worksheet Functions | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions |