Let's try again

[Brandy]

Ok, so Frank was on the right track, but not exactly what
I need. I'm going to try again.

I have a worksheet where I only need to know certain
criteria. I'm basically adding how many Caucasian Males,
Caucasian Females, Hispanic Males, Hispanic Females,
etc...

I have gender in one column (ex. B) and ethnicity in
another (ex. G).

So, I want it to count how many times there was a
Caucasian Male, etc.

So, I'm trying to combine the two pieces of information.

If I only have 52 lines of data and only saw 3 Caucasian
males, the answer I want is "3", not "6".

Make sense?

 

[Frank Kabel]

Hi
please stay in the original thread. Makes it easier. Besides this Peo
already gave you a solution using someproduct. So try something like
=SUMPRODUCT(--(B1:B100="male"),--(G1:G100="Caucasian"))

 

[CLR]

H Brandy.........

Another way to get there.........

=DCOUNTA(A:B,1,E1:F2)

where E1:F1 is your Criteria Table which you can vary
parametrically..........

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanks Frank... this was perfect!!!

-----Original Message-----
Hi
please stay in the original thread. Makes it easier. Besides this Peo
already gave you a solution using someproduct. So try something like
=SUMPRODUCT(--(B1:B100="male"),--(G1:G100="Caucasian"))

--
Regards
Frank Kabel
Frankfurt, Germany



.