I know this question has been asked over and over again, but I can't find an
answer that fits my needs. I have a range of status(ERDS), a range of
dates(ERDAY) and the column I need summed is ERQTY. I need the ERDS to equal
2, 43, 64 or 66, and the date to equal cell D2, then summing ERQTY if they
match the criteria. Can someone help me with this? This is the formula I've
used and am getting 0
=SUMPRODUCT((ERDAY=D$2)*(ISNUMBER(MATCH(ERDS,{2;64 ;43;66},ERQTY))))