Filtered Count Formula Needed

[Leesha]

Hi,
I have a report that I need to return the total for Female and Male from control [gender]. I tried =count([gender]="F") but it returned the total count for gender not just the female. What am I missing?
Thanks,
Leesha

[HansV]

Use

=Abs(Sum([gender]="F"))

[gender]="F" is True=-1 for females, and False=0 for males. So each female contributes -1 to the Sum. Abs removes the minus sign.

[Leesha]

Thanks Hans! I really appreciate the explanation so I understand the rationale for using again in a different scenerio.
Leesha