Hello All,

I know how to sumif with multiple criteria, yet I am stuggling to work out how to make the formula work when one condition is a substring of a cell.

I use the following when I have only one condition and it works

=SUMIF(Sheet1!$D:$D,"*22595847*",Sheet1!$E:$E)

But once I introduce an array with two conditions the "* *" no longer works.

=SUM(IF(Sheet1!$C$2:$C$64=DATEVALUE("2/03/2009"),IF(Sheet1!$D$2:$D$64="*22595813*",Sheet1!$E$2:$E$64,0),0))

Any suggestions???