Not COUNTIF, but SUMPRODCT will

=SUMPRODUCT(--(rng1="value1"),--(rng2=num2))

rng1 and rng2 must be the same size, and cannot be complete columns.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Geoff" wrote in message
ups.com...
Is it possible to have multiple criteria for a countif function?
Thanks.