I am a beginner-intermediate Excel user (good with math, not good with the power of excel). BTW, this is Mac MS Excel.
Scenario:
I have a workbook that tracks daily training stats. Each daily training sheet can be duplicated for as many days the user needs within the month. Each daily training sheet includes an area to track items used for training. Each item listed includes a CHECKBOX to identify whether or not it was used that day.
I want a summary sheet at the end that can provide totals for each item's total usage. It needs to identify checked boxes and ignore unchecked boxes. The catch here is that the number of sheets in the workbook will always change as the user creates new sheets for every day spent training.
For scenario's sake, the name of each sheet is the date of the month (i.e. 01,02,03,04, etc). I cannot just create 31 blank sheets, as some days are spent training multiple times and some days have no training.
How can I create a summary that can do this?
2007-12-14
03:59:17
·
3 answers
·
asked by
K9 Guy
2