Count if field is not blank and meets other criteria

Kristie Diersen

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!

Paul Newcome

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))

Paul Newcome

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))

Kristie Diersen

Thank you, that worked perfect.

Paul Newcome

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.