Countifs error

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


Sign In or Register to comment.