Trouble with a COUNTIFS formula
I can't figure out how to make a COUNTIFS formula to work.
This works: =COUNTIFS({Target Launch Date}, <=TODAY(30), {Target Launch Date}, >TODAY(0))
This works: =COUNTIFS({Header}, <>1)
This doesn't work: =COUNTIFS({Target Launch Date}, <=TODAY(30), {Target Launch Date}, >TODAY(0), {Header} <> 1)
----------
I'm getting an #INCORRECT ARGUMENT SET error
Target Launch Date = Date field
Header = Checkbox
(*I used Bold and Italicize to show components of the 2 formulas combined. I would have used colors, but not available.)
Best Answer
-
I reset the Target Launch Date reference, and it started working.
Here's the steps I took: Hover over the formula, click 'Edit Reference' and re-select the same column you (thought you) were referencing already...
Hope this helps someone
Answers
-
I reset the Target Launch Date reference, and it started working.
Here's the steps I took: Hover over the formula, click 'Edit Reference' and re-select the same column you (thought you) were referencing already...
Hope this helps someone
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 150 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!