SUMIF questions

[sharky12345]

I've got 2 issues I'm trying to resolve possibly with SUMIF?

1) I need to sum the values in I9:I7001 but only if B9:B7001 = A and E9:E7001 is not blank

2) I need to sum the values in D9:D7001 but only if B9:B7001 = A and C9:C7001 does not have the number 1

Can anyone help me please? I've struggled with this for some time!

 

[jacqueslegrand]

Hi,

You're gonna have to use a sumproduct !

1) = sumproduct((B9:B7001 ="A")*(E9:E7001<>"")*I9:I7001)
2)= = sumproduct((B9:B7001 ="A")*(C9:C7001<>1)*I9:I7001)

 

[sharky12345]

Perfect!

Many thanks!