Hi everyone
I have a quick question. I made a spreadsheet which looks as follows:
point values 1 2 3 4 5
study 1 10 6 2 1 5
study 2 7 4 3 9 2
study 3 8 3 1 4 7 etc....
Numbers 1-10 represent participants in a study. I wanted to know if there was a way for Excel to add up all of the point values corresponding to a specific participant, for example "3" (3+2=5). My spreadsheet is very long as I would rather not individually add up each point value.
Thanks!
Last edited by FDibbins; 03-12-2014 at 02:24 AM.
Can you post a small sample of how your spreadsheet looks like?
11 10 9 8 7 6 5 4 3 2 1 point values
5 8 2 1 6 10 4 7 11 3 9 question 1
5 8 2 1 10 6 7 11 3 4 9 question 2
8 5 2 10 6 7 3 11 4 9 1 question 3
5 11 10 6 2 4 8 1 7 3 9
5 8 2 1 6 10 4 7 11 3 9
5 7 1 4 2 9 6 11 10 3 8
1 5 7 2 3 4 6 8 9 10 11
8 1 2 10 4 6 3 7 5 11 9
8 5 2 7 4 6 10 11 3 1 9
8 4 7 2 5 6 10 11 1 3 9
Last edited by mickbowler; 03-12-2014 at 01:38 AM.
Hi and welcome to the forum
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I'm sorry, I meant attach a small example of your actual spreadsheet.
Attached is a small sample
Last edited by mickbowler; 03-12-2014 at 02:01 AM.
Thank for the title change
Last edited by FDibbins; 03-12-2014 at 02:06 AM.
Not sure what - or where you want this, but maybe this will get you headed in the right direction...
=SUMIF($B$2:$L$12,1)
This will add up all the values in your table that = 1
(also for future reference, to change your title for the entire thread, you need to change in in the 1st post - otherwise it will only apply to the post you change. I will do it for you - this time
I will remember that for next time lol
It ended up giving me 11 with the =SUMIF($B$2:$L$12,1) formula. I should be getting 67 (Sum of 11,10,9,8,8,8,4,3,3,2,1). Still a little stuck :/
OK your file is a little different from your explanation, the reason you got 11 (so did I) if because there were 11 instances of 1. If you want the sum of all the values in row 2, then try this in M2, copied down...
=SUM(B2:L2)
I'm a little confused with what you are looking for. You say you should be getting 67 by summing up 11,10,9,8,8,8,4,3,3,2,1, but where are you getting those numbers from?
So Participants 1 through 11 answered 11 different questions and for each question there is an 11 point rubric (top row). I wish to add all of the point values associated for each single participant. For example, Participant "1" appeared 1 time
under 11 points, once under 10, once under 9, three time under 8, once under 4, twice under 3, once under 2 and once under 1. I need to multiply the number of times the participant appears under a certain point value at the top by that top value and do this across the board {Sum of(1*B1)+(1*C1)+(1*D1)+(3*E1)+(1*I1)+(2*J1)+(1*K1)+(1*L1)}
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks