=SUMPRODUCT(--(A1:A100="a"),--(B1:B100="yes"),C1:C100)

--

HTH

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


"rita" wrote in message
...
I want to do a sumif but using 2 criterias which appear in 2 separate
columns
within the worksheet.

a yes 15000
a no 16000
a yes 20000
a no 30000
b yes 40000
b yes 50000

In the table above, I need to know the sum of column c if I choose a
criteria found in column a and column b together.
Can you help?
Thanks
Rita