|
|
|
|
Go to
tab 'Formulas', choose 'Error-checking' and 'Circular References'. Excel will
show you exactly in which cell(s) circular references are detected. |
|
|
NOTES FROM LAURA for new format |
|
|
|
|
|
|
|
If you add a new player into a
blank row on the Weekly Winnings sheet, add the same player to the same row
in the Total Winnings sheet |
|
|
|
|
|
|
|
Total and Average Gross uses
column heading "Gross" to select appropriate columns |
|
|
|
|
|
|
|
Total and Average Net uses
column heading "Net" to select appropriate columns |
|
|
|
|
|
|
|
I removed the "Table"
formatting because you have several header rows and merged cells and it was
causing problems. It will be simpler
to just change color on cells as needed when a new row is added. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cell S9,
Jason's Net amount for March 3rd at Ridgemark. Based on formulas for other dates, it
should be R9 (gross), not S9. I
changed it to R9. Please confirm if
that is the correct entry for that date. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|