Simple COUNTIFS formula w/ # INCORRECT ARGUMENT SET

Sam Lugiano

Hi,

I am having trouble with a COUNTIF formula. I am using the below formula that keeps giving me the INCORRECT ARGUMENT SET error message. I used the same formula to count the blank cells on another sheet and that worked, but this is not counting the not blank cells.

=COUNTIFS({Final Sent}, {Patient Status}, "Closed", {IV}, >=DATE(2019, 10, 24))

Thanks!

Sam Lugiano

I figured it out.

Heather Duff

Hi,

It looks like you're missing a criteria for {Final Sent}.

=COUNTIFS({Final Sent}, Criteria, {Patient Status}, "Closed", {IV}, >=DATE(2019, 10, 24))

I've put the missing argument in bold.

Best,

Heather

Sam Lugiano

Yes, I need the count for the cells that are not blank in the Final Sent Column. I've tried adding NOT(ISBLANK( but I was still getting an error message. I've used the below formula to get the Count in the same column but for the blank cells and it has worked.

I just can't get it for the not blank cells.

=COUNTIFS({Final Sent}, "", {Patient Status}, "Closed", {IV}, >=DATE(2019, 10, 24))

Sam Lugiano

I figured it out.

CKeiper

@Sam Lugiano How did you fix the issue for the non blank cells??

Sam Lugiano

That's a lot of formulas ago. I think I used the below formula or something like it. I can't find my original formula but I did check this one and it works.

=COUNTIFS({PATIENT STATUS}, "CLOSED", {IV}, >=DATE(2019, 10, 24), {FINAL SENT}, <TODAY())