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!
Best Answer
-
I figured it out.
Answers
-
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
-
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))
-
I figured it out.
-
@Sam Lugiano How did you fix the issue for the non blank cells??
-
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())
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!