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 D…
I'm attempting to write a SUMIFS formula where one of the criterion is to compare one date to another. It is returning 0 when it should return 1830. =SUMIFS({PURCHASING QTY EA}, {SHIP TO PLANT}, "HUBE…
I would like for the Conduit Ship Schedule column to return a date 14 days prior to the Forecast Production Date IF the Conduit on Inventory box IS NOT checked. So I wrote my formula that if checked, …
I'm trying to create a Sheet Summary formula to return the first date in a column and keep getting errors. I can't seem get it to look at the entire column or even a range. I've confirmed the referenc…