Try this...

=SUMPRODUCT((A2:A1000=4)*(B2:B1000="Male")*(C2:C10 00=2071))

Change each of the ranges to cover the maximum number of cells you will need
to use this formula over and the 4 in the first logical expression is an
assumed rank number (change that as necessary).

--
Rick (MVP - Excel)


"gene" wrote in message
...
I am trying to count the number of time a text srting appers. But, only if
it meets two other criterias. For Example I have three columb a is rank,
columb B is Gender and columb c is building. I want to count the number
of
times a particular rank appears in columb a but only if the gender is Male
and the building is 2071.

Can any one help me? By the way I need to do this in Excel 2003.