Hi guys,

I've been trying to enter multiple conditions in sumproduct formula for one column (A3:A3000). This one works, but is there a way to shorten it?

(SUMPRODUCT(--(DXB!A3:A3000="PM"),--(DXB!C3:C3000=1), DXB!G3:G3000))+(SUMPRODUCT(--(DXB!A3:A3000="NM"),--(DXB!C3:C3000=1), DXB!G3:G3000))

I essentially added two different sumproduct formulae here, but all i need for it to do is recognize both "PM" and "NM" in A3:A3000 column. A3:A3000={"PM,"NM"} doesnt work, tried.