close
No, you need to add another sumproduct, so that you hvae
=(original sumproduct) (new sumproduct)
where new sumproduct is
SUMPRODUCT(--(D35=quot;Order)quot;);--(F3:F5=quot;Directedquot;);--(E3:E5=quot;BOX017quot;);--(G3:G5=226);--(I3:I5))quot;carlquot; wrote:
gt; I use this formula:
gt;
gt; =SUMPRODUCT(--(D35=quot;Orderquot;);--(E3:E5=quot;BOX017quot;);--(G3:G5=226);--(I3:I5))
gt;
gt; I would like to add the condition: If D35=quot;OrderOquot; and E3:E5=quot;BOX017quot; and
gt; F3:F5=quot;Directedquot; and G3:G5=226. Not sure how to do this - do I need to use an
gt; OR operator ?
gt;
gt;
gt; Thank you in advance.
全站熱搜