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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()