How do I account for a specific status in a formula calculating expiration status?

Emily McNeeley

I am using the following formula to count the number of contracts that are expired

=COUNTIF([Contract Expiration Date]:[Contract Expiration Date], <TODAY())

I want to exclude any contracts that have "Archived" (Value) as the "Current Status" (Column) from this count.

David Tutwiler

=COUNTIFS([Contract Expiration Date]:[Contract Expiration Date], <TODAY(), [Current Status]:[Current Status], <> "Archived")

David Tutwiler

=COUNTIFS([Contract Expiration Date]:[Contract Expiration Date], <TODAY(), [Current Status]:[Current Status], <> "Archived")

Emily McNeeley

Thank you so much - worked perfectly!

David Tutwiler

No problem. Glad it's working.