COUNTIF matching two criteria

Pete Cardenas

I'm trying to count if, a row matches two criteria:

1. The row status is not "completed" (in another column)
2. If the current date is greater than the value in another column: "Due date".

So example:

Clean Bathrooms Not Completed 12/1/2020

The above row would be counted on the formula because it's not completed and past the due date.

Mark Cronk

Hi @Pete Cardenas ,

Sounds like you just need a COUNTIFS formula.

The syntax is:

=COUNTIFS( range1, criterion1, [ range2​criterion2​... ],...)

From your request I would expect your formula to be close to:

=COUNTIFS(Status:Status, <>"Complete" , [due date]:[due date], <Today())

Help?

Mark

Mark Cronk

Hi Pete, Perfect. Please mark my answer as accepted. Happy to help.

Mark

Mark Cronk

Hi @Pete Cardenas ,

Sounds like you just need a COUNTIFS formula.

The syntax is:

=COUNTIFS( range1, criterion1, [ range2​criterion2​... ],...)

From your request I would expect your formula to be close to:

=COUNTIFS(Status:Status, <>"Complete" , [due date]:[due date], <Today())

Help?

Mark

Pete Cardenas

Yup this does!

I didn't know if you could keep putting multiple criteria in the parenthesis.

Thank you!

Mark Cronk

Hi Pete, Perfect. Please mark my answer as accepted. Happy to help.

Mark