=SUMPRODUCT(--(rng1="value1"),--(rng2="value2"), rng_to_sum)

--

HTH

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


"frank" wrote in message
...
can i perform a SUMIF function with more than one
criteria.