Countifs error


I am trying to count the number of occurrences when column1 = value1 AND in the rows that have a check box in column2.

Can anyone see why this formula is #Unparseable? When tested individually, the formulas work but together I get an error.

=COUNTIFS([column 1]:[column 1], "value 1”, [column 2]:[column 2], "1")

=COUNTIFS([Placement /Evict /Non-renew /TE]:[Placement /Evict /Non-renew /TE], "Tenant Exchange”, [MI in 7d]:[MI in 7d], "1")

Thank you!


Best Answer


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help! 👍️

    Please don't forget to mark the most appropriate response(s) as helpful so that others searching for a similar solution can know that one may be found here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!