SUMIFS when date cell ISBLANK

BettyJo

I'm trying to add "if date cell is blank" criteria to my SUMIFS formula, but get "INCORRECT ARGUMENT SET"

=SUMIFS({EBOM - 4" CONDUIT QTY}, {EBOM - 4" JOINT TYPE}, "GSK", (ISBLANK({EBOM - ACTUAL PROD DATE})))

What am I doing wrong?

Jason Tarpinian

You are combining your Range2 + Criteria2 of the EBOM - ACTUAL PROD DATE, you first define the range, then the criteria by separating with a comma (so the #INCORRECT ARGUMENT SET is that you don't have a criteria for the range).

=SUMIFS({EBOM - 4" CONDUIT QTY}, {EBOM - 4" JOINT TYPE}, "GSK", {EBOM - ACTUAL PROD DATE}, ISBLANK(@cell))

The @cell is used because ISBLANK is being used for criteria in an entire range, instead of a specific cell, so you use @cell to tell the formula to look at every cell within that range individually.

Jason Tarpinian

You are combining your Range2 + Criteria2 of the EBOM - ACTUAL PROD DATE, you first define the range, then the criteria by separating with a comma (so the #INCORRECT ARGUMENT SET is that you don't have a criteria for the range).

=SUMIFS({EBOM - 4" CONDUIT QTY}, {EBOM - 4" JOINT TYPE}, "GSK", {EBOM - ACTUAL PROD DATE}, ISBLANK(@cell))

The @cell is used because ISBLANK is being used for criteria in an entire range, instead of a specific cell, so you use @cell to tell the formula to look at every cell within that range individually.

BettyJo

That worked! Thank you so much!