Counting data by age group, gender, and other variables

[Biomedical]

Hi All,

I work in a physical therapy clinic where we do rehab in ACL knee injuries. Having said this, I've been collecting data over a 6 month period to determine the measure of improvement in knee function. Now I have all this data in an excel spread sheet, however, I have few questions regarding how to program a few things:

1) One column is a gender column, in it is either "M" or "F". At the end of the column I would like to count how many "M"s and "F"s.

2) One column is age group, in it ages ranges from 16-50 years of age. At the end of the column I would like to determine how many individuals are A) 20 and younger, B) 40 and younger, and C) above 40 .

3) Last column is improvement, in it is either "very good" "moderate" "none". At the end of the column, I would like to determine how many of each rating is observed (i.e sum them).

Thank you for your help !

[NBVC]

1. use Countif ...e.g. =Countif(A1:A100,"M") for Male

2. use Countif... e.g. =Countif(B1:B100,"<=20")

3. use Countif ... e.g. =Countif(C1:C100,"Very Good")