I am a noob when it comes to excel but wanted to know if it was possible to have a tally running on several sheets and adding all the tallies from the sheets on a final sheet of a workbook.
So the workbook would set up as follows:
Each sheet (of which there are 8) would have:
Row 1 as the titles for each column.
Column A - "Players Name"
Column B - "Super Star"
Column C - "Bills Logo"
Column D - "Football"
Column E - "Offense"
Column F - "Defense"
Under Column A from A2:A29 - will list each players name.
For B2:F29 - will be Tally marks for each sticker a player earn in the game. Each game will be tallied on a seperate page and the totalled on the last page, in each of the cooresponding columns.
My questions for all who can help are:
How do you make tally marks? I read about the marlett font to make checkmarks but how would you make the tally marks countable. Is it possible to have those tally/checkmarks display as a numerical value after entering them? or have the value for all the tally marks display on the totals sheet?
I know about the SUM function and that could be the solution to adding all the values from the sheets to the total sheet at the end of the workbook, but I guess converting the tally marks to a numerical value would be the easiest option. Any ideas?
Bookmarks