Multiple IFS problem

i had to change the dates to a number so we can use > or <

to do that i used > DATA > TEXT to COLUMNS

=COUNTIFS($B$2:$B$12,"female",$C$2:$C$12,">="&LEFT(H$2,4)*1,$C$2:$C$12,"<="&RIGHT(H$2,4)*1)

=COUNTIFS($B$2:$B$12,"male",$C$2:$C$12,">="&LEFT(H$2,4)*1,$C$2:$C$12,"<="&RIGHT(H$2,4)*1)

you are welcome

Edited: Formula had small error. Now corrected.
I'm a little late but here's another way.

This may have to be array entered in cell H3 then copied down and across.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

Please see the attached.This is a simpler version of the same approach. I simplified the table layout and data. Then used this formula (probably array entered) in H4 copied down and across.

Formula:

Please Login or Register  to view this content.