For all you Excel guru's, not only do I need an answer, I need to know how to
ask the question. Please bear with me and thank you for your time.

I have a spreadsheet with multiple tabs (worksheets?) and I am using the
first one as a cover sheet type doohickey. The following pages are set up to
track who has done what training by section, then all that comes together on
the cover sheet. So imagine if you will about a dozen tabs named for each
work section, with a list of names that work in that section and then about
thirty columns labeled with the training requirement and whether the person
has done it or not. Eezy peezy.

It gets complicated when 'they' (the powers that be) want to know the grade
the person passed (or failed) by. So next to the column labeled PFT (or
Physical Fitness Test) for example is a column asking what class (or grade)
the person got; 1st class, 2nd, 3rd, Failed and partial. So in that column
there are multiple 'values' I guess they're called. A bunch of 1s and 2s, a
few 3s and Fails.

Now, on the cover sheet, I have the percentage of how many people ran a PFT,
in this case %56.67 of the people have ran a PFT. What I need now is the
number of people who got a 1st class, 2nd class and so on. Not a percentage,
but an actual number. The old way of doing this would have me go through each
tab and count how many 1s I have in that column and then how many 2s, etc.

Is it possible for me to put on the cover sheet that I have 105 1s, 52 2s
12 3s, etc? Let me rephrase that. Is there anyway to do this automatically?
Ive tried, and please dont think less of me, to understand vlookup, index,
match and other formula types but its mostly gibberish to me. Please help.
It takes too dern much time to look up this info on over 300 people.

Again Thank You.