No, you need to add another sumproduct, so that you hvae

=(original sumproduct) + (new sumproduct)

where new sumproduct is

SUMPRODUCT(--(D3:D5="Order)");--(F3:F5="Directed");--(E3:E5="BOX017");--(G3:G5=226);--(I3:I5))


"carl" wrote:

I use this formula:

=SUMPRODUCT(--(D3:D5="Order");--(E3:E5="BOX017");--(G3:G5=226);--(I3:I5))

I would like to add the condition: If D3:D5="OrderO" and E3:E5="BOX017" and
F3:F5="Directed" and G3:G5=226. Not sure how to do this - do I need to use an
OR operator ?


Thank you in advance.