"SUMIF + and" Formula Help Please

[garymu16]

=sumif($C$4:$C$428,H5,and($E$4:$E$428,"x",$D$4:$D$428))

Can anyone point out the mistake I've made in the formaula highlighted above?

Thanks
Gary

 

[Robert Mika]

Try this:
=SUMPRODUCT(--($C$4:$C$428=H5),--($E$4:$E$428="x")*$D$4:$D$428)

 

[garymu16]

Perfect - Thank you Robert!

 

[T. Valko]

=sumif($C$4:$C$428,H5,and($E$4:$E$428,"x",$D$4:$D$428))

Can anyone point out the mistake I've made in the formaula highlighted above?

Thanks
Gary

If you're using Excel 2007 or later you can use the SUMIFS function.

=SUMIFS($D$4:$D$428,$C$4:$C$428,H5,$E$4:$E$428,"x")

 

[T. Valko]

Try this:
=SUMPRODUCT(--($C$4:$C$428=H5),--($E$4:$E$428="x")*$D$4:$D$428)

No need to multiply the sum_range.

=SUMPRODUCT(--($C$4:$C$428=H5),--($E$4:$E$428="x"),$D$4:$D$428)

 

[Robert Mika]

garymu16,
You are welcome.


Beef,
Thanks for another lesson.