I have a “Sex” field in a Base report (tabular) that I want to count the number of females or males in that report, what is the formula that I should use? I tried sum and if combo; and count and if combo both produced a wrong answer.
Hi
try:
=COUNTIF(A1:A50,“m”) using whatever range of cells include your “sex” column. Same if you want to count the "f"s
cheers
You may have missed that the question is about Base, not Calc.
sorry my bad 