I would like to be able to count unique values in multiple worksheets with multiple criteria.
In my workbook I have 3 worksheets that contain the following:
Column A - registrant's unique id #
Column B - registration status. I'm looking for "accepted" values.
Column F - registrant's gender
I want to count the number of unique registrants who are both "accepted" and "male" in worksheets 1, 2, and 3.
I've done several searches and I can't seem to make any of the formulas I've found work for me.
Thanks,
Craig
Bookmarks