Hi!

=SUMPRODUCT(--(Range1=Criteria1),--(Range2=Criteria2))

Ranges cannot be entire columns ---- A:A (entire rows is ok ---- 1:1)
Ranges must be the exact same size: Range1 = A1:A10 ---- Range2 = H1:H10 or
A1:A10 ---- H11:H20
If the criteria is a text value enclose it in quotes ---- "Green"
If the criteria is a numeric value don't enclose it in quotes ---- 10

Biff

"Chip Smith" wrote in message
...
i need to do a count based on two differnt criteria and two different
ranges...like a =countif((range,criteria)&(range,criteria)) or something
of
that nature
--
--Chip Smith--
MVP Wannabe :)