How to COUNTIFS when cell is blank and not today.
I need to know how to return a value by these parameters.
- There is a column named Completion Date. If it is blank, I need it counted.
- I need it to look at another column named Service Date and count if that date is in the past (not today or in the future).
- So, I just need it counted if it is blank and earlier than today.
=COUNTIFS([Completion Date]:[Completion Date], ISBLANK(@cell), AND([Service Date]:[Service Date], < TODAY(@cell)))
I keep getting a #UNPARSEABLE error.
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.