View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Millerk
 
Posts: n/a
Default 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.