Invalid Data Type error

DanielGD

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

Mike Wilday

Try this instead. 

=Countifs(FacilityCount:FacilityCount, "TZ", Status:Status, <>"Green")

Countifs checks against multiple criteria and ranges. 

<> means "does not equal" so count every facility with TZ that does not have a status of green.

DanielGD

Works perfect. Thanks. I missed the difference between COUNTIF and COUNTIFS.

Mike Wilday

You're welcome! Glad I could assist.