COUNTIFS function

SHEILA.PARKINS90381

I have two columns that I am using, one is a checkbox column, the other is a date column. I want to know, of those that have a checkbox checked in one column, how many of them come after the date 07/01/2019 in the other column. Does anyone know the syntax for that? The column names. The checkbox column is "Approved", the date column is "Date Received". Thanks!!

Nic Larsen

Try this: 

=COUNTIFS([Date Received]:[Date Received], >=DATE(2019, 7, 1), Approved:Approved, 1)

Mike Wilday

Do be aware that the >= sign will take into account 7/1. Remove the equal sign if you truly want greater than 7/1/2019.

SHEILA.PARKINS90381

Thanks much!

Mike Wilday

I'm glad we could help you out!