Simple COUNTIFS formula w/ # INCORRECT ARGUMENT SET

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!

Find more posts tagged with

Accepted answers

Sam Lugiano

I figured it out.

All comments

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())

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.