count if check box is not checked (2) and requested date is within a date range

Johnnie LaCaze

I am trying to get a count of each row on my sheet that meets the following criteria. 

Children of ([Requested Date]17) (which is date format column) is between 1/1/18 - 1/31/18

and

Children of (Canceled17) (which is check box format) is not checked (0)

and

Children of ([Not Owner]17) (which is a check box format) is not checked (0)

 

I am currently using this formula to get my monthly count for Requested Date

=COUNTIFS(CHILDREN([Requested Date]$17), @cell >= DATE(2018, 1, 1), CHILDREN([Requested Date]$17), @cell < DATE(2018, 2, 1))

but I need to factor in the criteria above and I was hoping to only have one formula. Is that possible?

 

Thanks in advance

Paul Newcome

This should work for you. Just add the other two requirements into your COUNTIFS function:

 

=COUNTIFS(CHILDREN([Requested Date]$17), @cell >= DATE(2018, 1, 1), CHILDREN([Requested Date]$17), @cell < DATE(2018, 2, 1), CHILDREN(Canceled$17) = 0, CHILDREN([Not Owner]$17) = 0)