Need Help with Sumproduct

[JHL]

This formula works because I found it in this forum and have applied it. Now
I want to use it for 3 conditions, but my 3rd condition is also in the column
range of C3:C46, but the condition is H4.


=SUMPRODUCT(--($A$3:$A$46=F3),--($C$3:$C$46=H3),
--($C$3:$C$46=H4),$D$3:$D$46)


When I insert the additional c3:c46 into the formula, the result is $0,
instead of the sum I'm looking for. I need to keep these particular
conditions in col C.

Any suggestions on how to overcome this?

Thanks

 

[Billy Liddel]

Try
=SUMPRODUCT(--($A$3:$A$46=F3),--($C$3:$C$46=H3)+($C$3:$C$46=H4),$D$3:$D$46)

HTH
Peter

 

[Paul C]

The conditions --($C$3:$C$46=H3) and --($C$3:$C$46=H4) will exclude each
other unless H3=H4

without some more detail I cannot be certain of your intent, but I think you
may want two sumproduct formulas added together.

=SUMPRODUCT(--($A$3:$A$46=F3),--($C$3:$C$46=H3),$D$3:$D$46) +
SUMPRODUCT(--($A$3:$A$46=F3),--($C$3:$C$46=H4),$D$3:$D$46)

This will total all values in D346 where A=F3 and C=H3 or C=H4