Invalid Data Type error

DanielGD · 02/09/18

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 · 02/09/18

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 · 02/09/18

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

Mike Wilday · 02/13/18

You're welcome! Glad I could assist.

Comments