=SUMPRODUCT(--(rng="value1),--(rng=number2))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rodman" wrote in message
...
I am using Excel 2003 and I would like to count the number of cells within
a
range thar meet multiple criteria. (Note this function is availiable in
2007
as COUNTIFS).

Can anyone help?
Thanks In Advance
--
Rodman Veney