Countifs with checkbox, blank date
Hello,
I am trying to use the countifs to count a reference sheet when a checkbox is checked and a date is blank.
I know the first part is "=COUNTIFS({referenced sheet checkbox}, 1," I'm just not sure what to use for the second portion.
I think the closest is:
=COUNTIFS({reference sheet checkbox}, 1, AND({referenced sheet date}, ISBLANK(@cell)))
The error message with this one is INVALID DATA TYPE.
Any suggestions?
Best Answer
-
Try this...
=COUNTIFS({reference sheet checkbox}, 1, {referenced sheet date}, @cell = "")
Answers
-
Try this...
=COUNTIFS({reference sheet checkbox}, 1, {referenced sheet date}, @cell = "")
-
That worked, thank you. :)
-
Happy to help. 👍️
-
So I'm trying to do the reverse of this: CountIfs the checkbox is blank but the date is filled in. Can either of you help me get that formula to work?
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives