=SUMPRODUCT(--(rng1="string_value"),--(rng2=numeric_value2), rng_to_sum)

--

HTH

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


"alice" wrote in message
...
how do I put to IF's into one formula?