Excel.png

Hi Everyone,

I'm looking for a formula that will Count the number of Male and Females but ONLY when there is a name in column A. It would ignore the count if column A is blank.

I've tried Countifs setting A:A"<>0", B:B, "Male") that didn't quite do it. Any suggestions. The sheet is 500 columns long and we're creating a dashboard to show progress