Countif and Contains formula

Maria Watters

Hello,

I am needing a formal that counts items that are the following:

Range 1 = Consultation

Range 2 = Completed

Range 3 CONTAINS Ute Mountain Ute Tribe

The below is what I have, but it says it is umparseable.

=COUNTIFS({CDHS Tribal Team Range 1}, "Consultation", {CDHS Tribal Team Range 2}, "Completed", ({CDHS Tribal Liaison Team Activity Log Range 1}, CONTAINS("Ute Mountain Ute Tribe", @cell)))

Ramzi K

@Maria Watters

Looks like too many parentheses maybe?

Does this work instead?

=COUNTIFS({CDHS Tribal Team Range 1}, "Consultation", {CDHS Tribal Team Range 2}, "Completed", {CDHS Tribal Liaison Team Activity Log Range 1}, CONTAINS("Ute Mountain Ute Tribe", @cell))

Cheers,

Ramzi

Ramzi K

@Maria Watters

Looks like too many parentheses maybe?

Does this work instead?

=COUNTIFS({CDHS Tribal Team Range 1}, "Consultation", {CDHS Tribal Team Range 2}, "Completed", {CDHS Tribal Liaison Team Activity Log Range 1}, CONTAINS("Ute Mountain Ute Tribe", @cell))

Cheers,

Ramzi

Maria Watters

@Ramzi K

Thank you! That was the problem!