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

edited 12/09/19

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?

Tags:

• ✭✭✭✭✭✭

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)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!