close

I use this formula:

=SUMPRODUCT(--(D35=quot;Orderquot;);--(E3:E5=quot;BOX017quot;);--(G3:G5=226);--(I3:I5))

I would like to add the condition: If D35=quot;OrderOquot; and E3:E5=quot;BOX017quot; and
F3:F5=quot;Directedquot; and G3:G5=226. Not sure how to do this - do I need to use an
OR operator ?Thank you in advance.

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

    software

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

    E-mail轉寄