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

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
ups.com...
I need to create a formula that will search through multiple columns
for different criteria and then give the sum of another column based
upon the search results. I tried using SUMIF, but it will only search
through one set of criteria. I need it to search for multiple criteria.