Percentages and counting
I have a spreadsheet used to track student participation in different
activities offered. The main spreadsheet lists the names of the student,
their DOB, age, gender and race. If they participate in a particular
activity, an X is placed in the corresponding cell out past their name. A
separate sheet will contain statistical data for each activity.
The stats sheet needs to contain the following information:
Age breakdown by gender (i.e. x # of 4 year old boys)
The next calculation will tell % of participation based off race
I'm still searching the various post to find the answer, but any help before
I find the answer is greatly appreciated.
|