Hi,

Your discription suggest that the quickest and most elegent solution might
be a pivot table.

If you want a non-pivot table solution in 2007 you could consider
=COUNTIFS(Race,"Hispanics",Gender,"Male")
is an example, where Race is the column containing race and Gender is the
range containing the gender. You can expand this to handle three criteria at
the same time if necessary.

In 2003 you will need something like
=SUMPROODUCT((Race="Hispancis")*(Gender="Female"))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Jerry Edge" wrote:

I have a spredsheet with 10 codes and a database with a list of data with
three columns one is headed code, (same as the 10 codes), one headed Race and
one headed Gender. I am truing to count by race and by gender and by code.
For example, I am trying to count all of the Hispanics that are also males
that fit into clde 2.

--
Jerry Edge