Thread: Looking up a sum of data in several columns for specific values of another column

I have the formula:

=(SUMIF($J:$J, "Player1",$K:$K)+SUMIF($L:$L,"Player1",$M:$M)+SUMIF($N:$N,"Player1",$O:$O))-SUM($I:$I)

This looks up if Player 1 was in the top 3 scoring zones and adds up the players total score.

I have another column in this table of data labelled 'Number of Players'. I was wondering how to lookup the total score for this player in the games he played under 6 players for example and the games he played in where there were other six players.

I've tried using that formula ^^ with variations of IF and SUMIF formulas to try and figure it out, but I keep getting formula errors or it just returns with the total score, and not just with the total score under 6 players.

I am also trying to create a graph of date on the x axis against score to date on the y axis - everytime I try, the x axis is always numbers instead of the date? :S

Any help?

Cheers
Matt

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Nope, you didn't. When attaching the file, browse to it and then be sure to click the Upload button. The site will accept .xls or .zip formats (and possibly even .xlsx now too!).

Paul, it was attached in original post...

Mawhood, not sure if this is what you mean:

In C7
=(SUMIFS($K:$K,$F:$F,"<6",$J:$J, "Player1")+SUMIFS($M:$M,$F:$F,"<6",$L:$L,"Player1")+SUMIFS($O:$O,$F:$F,"<6",$N:$N,"Player1"))

and in C8

=(SUMIFS($K:$K,$F:$F,">=6",$J:$J, "Player1")+SUMIFS($M:$M,$F:$F,">=6",$L:$L,"Player1")+SUMIFS($O:$O,$F:$F,">=6",$N:$N,"Player1"))

not I include =6 in second formula.. you may need to adjust to top formula.

Also note: You can easily make like more simple, if you say put Player 1 in Cell C2, then replace all references in the formula of "Player 1" to C2... then you just change C2 and formulas would auto recalc.

I mentioned before.. please keep separate "unrelated" questions in separate threads... this will help future users find similar topic and be hopefully able to resolve their own issues when needed....and be specific about what you are trying to plot...

Please mark this thread Solved.