Count if field is not blank and meets other criteria
I need help with a formula. I am trying to do a count of all of the fields where CP60 is not blank if the Check In is Initial Review of Plan and if the Month is 4 and the Year is 2023. I cannot figure out what formula to use here.
Thanks!
Kristie Diersen 😀
Best Answer
-
Try something like this:
=COUNTIFS({CP60}, @cell <> "", {Check In}, @cell = "Initial Review of Plan", {Date Of Coaching}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2023))
Answers
-
Try something like this:
=COUNTIFS({CP60}, @cell <> "", {Check In}, @cell = "Initial Review of Plan", {Date Of Coaching}, AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2023))
-
-
Happy to help. 👍️
NOTE: The above also eliminates the need for the Month and Year columns since we are able to evaluate the date column directly.
Help Article Resources
Categories
Check out the Formula Handbook template!