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?