| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Frequency
I am trying to run a daily total of the # of responses to 5 questions. Each
question has 5 possible responses. Question 1 had 5 responses rated as 5, questions 2 had 2 responses rated as 2, etc. I thought I could create a formula, but I'm stumped. TIA. Q1 Q2 Q3 Q4 Q5 5 11 7 13 6 2 4 5 6 3 3 4 3 5 4 0 1 0 2 3 0 1 0 0 0 How many 5 responses to question 1? How many 4 responses to question 1? etc. Mudbug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Frequency.... I think | Excel Worksheet Functions | |||
| Frequency ( ) | New Users to Excel | |||
| Frequency | Excel Discussion (Misc queries) | |||
| frequency | Excel Discussion (Misc queries) | |||
| histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
Threaded Mode
