counting formulas needed

[SBURTON]

First formula needed:
I have a training spreadsheet with a column that I want to put a Y (stands for training required), an N (stands for training not required), or the date (10/12) when training was done. I need a formula that I can put at the bottom of each column that will tell me how many people require training in that column. In other words I need it to count the Y's and the dates but not count the N's.

Second formula needed:
Then once that figures how many people are required to do the training I would like a formula in the box below that one that would give me the percentage of employees that have completed training. In other words the formaula I think would needs to take the previous answer and somehow use the qty of boxes with the dates (training completed already) to give me a percentage of employees that have completed training.

Any help would be appreciated.

[benishiryo]

hi SBURTON. assuming your data is in A1:A10, try this for the 1st one:
=COUNTIF(A1:A10,"<>"&"n")

and assuming the 1st formula is in Cell C5, try this formula for the 2nd:
=COUNTIF(A1:A10,">1")/C6

[SBURTON]

benishiryo, perfect, your amazing, the people on this forum are so helpful and smart!