ExcelBanter - Adding "OR" to a Sumproduct Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding "OR" to a Sumproduct Formula (https://www.excelbanter.com/excel-worksheet-functions/78787-adding-sumproduct-formula.html)

carl

Adding "OR" to a Sumproduct Formula

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.

All times are GMT +1. The time now is 01:21 AM.