=SUMPRODUCT((A4:A12=3)*(B4:B12="Yes")*(C4:C12))

"DME" <craigjoseathotmaildotcom wrote in message
...
Is there a function similar to SUMIF that would take two criteria into
consideration? For instance

I want to sum all cells in Column C if Column A =3 and Column B =Yes.

I know sumif will work for 1 criteria but cannot seem to think of how to
make it sum for two.

thanks for the help.