Microsoft Excel: How to count Male and Female, Male:Female ratios (including rounding)

Formulae in description. A quick video showing easy ways to determine how many male/female subjects you have, the percentage of sex within a group, the ratio of a group, and how to change the ratio (greatest common denominator and rounding). Number of males: =COUNTIF(C2:C20, "M") Number of females: =COUNTIF(C2:C20, "F") %Males: =C22/(C22+C23)*100 M:F =(C22/C23)&":"&(C23/C23) M:F (rounded) =ROUND((C22/C23),1)&":"&(C23/C23) M:F (Greatest common denominator) =(C22/GCD(C22:C23))&":"&(C23/GCD(C22:C23))