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))


свернуть