Countif with multiple criteria

[MI man]

Hello All,

I have a table in Excel 2003 in which I have to do a countif with the multiple criteria.

Say, I have to count the number of people of a particular Race in a country in a continent

(Eg: Count of Caucasian Race in a country (Japan), which is in continent (Asia).

I have got the pick list for continent and the Country pertaining to that continent, but how to count the Race, based on these criteria....
Like this, I have got to count different races in a same country.

Please help on how to do this in Excel 2003.

 

[Brianwarnock]

This is probably a job for Sumproduct
Sumproduct((range1=criteria1)*(range2=criteria2)*(range3=criteria3))
Criteria can be a cell reference or specific "Japan"

 

[MI man]

Hey Brian,

Thanks for the solution.

I think I have to stress more on learning the array formulae.

Thank you very much.