I am trying to count the number of cells that meet two different criteria.

ISP Agreements

My first formula counts the number of agreement that haven't been signed, but excluding "_signed".

=COUNTIFS({Future Agreements Tracking Range 6}, NOT(CONTAINS("_signed", @cell)))

This works fine

I can also count the number of agreements that are renewals

=COUNTIFS({Future Agreements Tracking Range 1}, "renewal")

However, I would like to count the number of agreements that are not signed and renewals. I have tried the following formula, but it doesn't work. I also want to count the number of rows that meet both criteria.

I have tried the following:

=COUNTIFS({Future Agreements Tracking Range 6}, NOT(CONTAINS("_signed", @cell), {Future Agreements Tracking Range 1}, CONTAINS("Renewal", @cell)))

=COUNTIFS({Future Agreements Tracking Range 6}, NOT(CONTAINS("_signed", @cell)), {Future Agreements Tracking Range 1}, "renewal")

Paul Newcome

Your first formula has an extra closing parenthesis on the end...

=COUNTIFS({Future Agreements Tracking Range 6}, NOT(CONTAINS("_signed", @cell), {Future Agreements Tracking Range 1}, CONTAINS("Renewal", @cell))