Count using multiiple Criteria
Try this:
Use cells to hold your criteria.
E1 = the rank to count
F1 = male
G1 = 2701
=SUMPRODUCT(--(A2:A100=E1),--(B2:B100=F1),--(C2:C100=G1))
--
Biff
Microsoft Excel MVP
"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.
|