How to keep cumulative total for a weekly poker game spreadheet

Patryd

New Member
Joined
Dec 11, 2020
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Hi, I have a weekly online poker game that has about 30 participants. I have a spreadsheet that tracks buy ins, rebuys, amount won, total profit or loss. I have drop down boxes and formulas in a number of the cells. The sheet changes each week depending on who actually plays that week. I want to keep track of the totals from each week as a running total for each player. Do I have to have a separate sheet for each week, or can i erase the data weekly on the sheet while still keeping a running total somehow?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,214,827
Messages
6,121,816
Members
449,049
Latest member
cybersurfer5000

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top