I was able to work it with

=SUMPRODUCT(--(A:A=criteria),--(B:B=criteria),(C:C))
assuming B is your sumif criteria and c has your sum values.

May work the same as pinmaster's. I'm not sure...

"pinmaster" wrote:

Hi,

Maybe something like:

=SUMPRODUCT((A1:A100="John")*(B1:B100="Doe"),C1:C1 00)

HTH
Jean-Guy

"Sandy@law" wrote:

I need a formula that will look at column A and if meets the criteria then do
a SumIf based on two other columns with another criteria.