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
Bookmarks