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
Check out the Formula Handbook template!