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")