=SUMPRODUCT(--(rng1="criteria1"),--(rng2="criteria2"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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 :)