This might not be what you're looking for BUT, if you substitute the
use of number 1 instead of placing X in the appropriate column then you
could use =SUMIF($G:$G,"A-Town",H:H).

Note that the lookup range is absolute while the return range is
relative, so copying it to the appropriate column to count females
works there as well.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc