 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / December 2007Frequency
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 I think your looking more for the count function. Use this function. =COUNTIF(A2:A8,">*") > 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, [quoted text clipped - 12 lines] > > Mudbug Wow--that was fast! I tried that formula, but I must be putting in the wrong cell? I don't think I explained it well enough either. Where would I put it based on the following? Do I create a column for each question? Two people gave a 5 response to Q1. Two gave a 5 response to Q4. Person Q1 Q2 Q3 Q4 Q5 Mr. C. 5 3 2 5 1 Mr. L 5 5 5 5 5 Mr. T 4 4 3 3 3  SignatureMudbug > I think your looking more for the count function. > [quoted text clipped - 17 lines] > > > > Mudbug I take it the responses are a value of a rating of the question. Thus, 5 being completely agree and 0 being completely disagree (or something along that line). So, if you want to count all the 5, 4, 3, 2, 1, & 0's, just insert the number of rows at the top you need (0 to 5 would be 6 additional rows). Be sure to change the range to first and last row of all questions. Formula =COUNTIF(B$8:B$16,"=5"), =COUNTIF(B$8:B$16,"=4"), =COUNTIF(B$8:B$16,"=3"), etc... Fill to the right for each question. Here's Result A B C D E F Tally 5 2 1 1 2 1 Tally 4 1 1 0 0 0 Tally 3 0 1 1 1 1 Tally 2 0 0 1 0 0 Tally 1 0 0 0 0 1 Tally 0 0 0 0 0 0 Person Q1 Q2 Q3 Q4 Q5 Mr. C. 5 3 2 5 1 Mr. L 5 5 5 5 5 Mr. T 4 4 3 3 3 > Wow--that was fast! I tried that formula, but I must be putting in the wrong > cell? I don't think I explained it well enough either. Where would I put it [quoted text clipped - 26 lines] > > > > > > Mudbug TYTYTYTYTY!!!!!!! You are awesome M !! SignatureMudbug > I take it the responses are a value of a rating of the question. Thus, 5 > being completely agree and 0 being completely disagree (or something along [quoted text clipped - 50 lines] > > > > > > > > Mudbug Assume this table is in the range A1:F4 - Person Q1 Q2 Q3 Q4 Q5 Mr. C. 5 3 2 5 1 Mr. L 5 5 5 5 5 Mr. T 4 4 3 3 3 Enter these headers in the range B10:F10 - Q1, Q2, Q3, Q4, Q5 Enter these headers in the range A11:A15 - 1, 2, 3, 4, 5 Enter this formula in B11 and copy across to F11 then down to row 15: =COUNTIF(INDEX($B$2:$F$4,,MATCH(B$10,$B$1:$F$1,0)),$A11) SignatureBiff Microsoft Excel MVP >I am trying to run a daily total of the # of responses to 5 questions. >Each [quoted text clipped - 13 lines] > > Mudbug |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.