Getting an Invalid Data Type error with this formula:
=COUNTIF(AND(FacilityCount:FacilityCount, "TZ"),NOT(COUNTIF(Status:Status, "Green")))
The second "CountIf" is a symbols column.
Looking to make a count of certain 2-letter codes if the status column does not have a "Green" ball.
Thanks