summing up calculations

[tiger8380]

Hello,

I am new here so if I don't format this correctly please just let me know. I want to make an excel sheet that records games played (of warmachine) and the points a player gets for playing/winning those games and then have those scores properly tallied on a "general" worksheet. I have created the game information and it correctly calculates points for winning and losing a game. I have even created a method of tallying those points but the way I have devised would require a HUGE nested if statement.

What I have made was this:

=SUM(IF(COUNTIF(B2:B7,'General information'!A2),IF(COUNTIF(D4:D5,'General information'!A2),G5,G6),0),IF(COUNTIF(B9:B14,'General information'!A2),IF(COUNTIF(D11:D14,'General information'!A2),G12,G13),0),IF(COUNTIF(B16:B21,'General information'!A2),IF(COUNTIF(D18:D21,'General information'!A2),G19,G20),0))

That's only to sum up 3 of the games based on a users name. I am really hoping that you guys can help me find a better/easier way to get this to work. I have to make it so this sheet can calculate around 40-50 games and as you can imagine by the length of that code alone for just 3 games, the manual data input would be huge.

Please help me out.

 

[pplstuff]

There is probably a much simpler solution. Could you post sample data and the desired solution?

 

[tiger8380]

There is probably a much simpler solution. Could you post sample data and the desired solution?

Now there is more than 1 player per game and possibly more than one winner. So I need it to add points for whoever wins in the game played section and points for losers as well. This needs to be tallied from over 40 different "game played" setups. I hope this helps make it clearer what I am looking to do.

 

[pplstuff]

You should consider putting this data into a database format (where 1 row is one record). Then you can solve using a sumif() function.

If you like this idea of having the "form" to enter your data - watch this video for details how how to enter your data into the form, and store it in a database.
http://www.youtube.com/watch?v=4gzW8QGiom8&feature=g-all-u