COUNTIF Text Cell

Mike Buckiewicz

Hi All,

I am struggling with this formula to count based on a text field search then qualifying with status drop down type. Still getting errors as I know II am missing someything.

=COUNTIFS({Project Oversight Range 6}, ([Triversity Construction]@row), {Project Oversight Range 2}, "To Do") + COUNTIFS({Project Oversight Range 6}, ([Triversity Construction]@row), {Project Oversight Range 2}, "In Progress") + COUNTIFS({Project Oversight Range 6}, ([Triversity Construction]@row), {Project Oversight Range 2}, "Support")

Pointers would be great.

Paul Newcome

Are you able to provide more details behind the logic of what you are wanting to accomplish?

Genevieve P.

Hi @Mike Buckiewicz

To add to Paul's request, could you also identify what type of error you are receiving, and what type of columns each of your ranges/references are?

Thanks!

Genevieve