# summing up calculations

#### tiger8380

##### New Member
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.

=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.

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
There is probably a much simpler solution. Could you post sample data and the desired solution?

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.

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.

Replies
1
Views
445
Replies
2
Views
230
Replies
4
Views
1K
Replies
10
Views
647
Replies
4
Views
265

1,203,668
Messages
6,056,653
Members
444,880
Latest member
Kinger1968

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back