COUNTIFS Formula

Lynn Meadow

I am fairly new to working with formulas. I have a Project Status column that contains several values with "In Progress". For example, In Progress - Scoping, In Progress - Development, etc.

I would like to count all the instances of any variation of In Progress. I have tried working with HAS and CONTAINS and recently came across FIND. I just can't seem to get the syntax correct.

This is where i left off!! I would appreciate any help.

=COUNTIFS([Project Status NEW]:[Project Status NEW], FIND("In Progress",[Project Status NEW]))

Andrée Starå

Hi Lynn,

Try something like this.

=COUNTIF([Project Status NEW]:[Project Status NEW]; CONTAINS("In Progress"; @cell))

The same version but with the below changes for convenience.

=COUNTIF([Project Status NEW]:[Project Status NEW], CONTAINS("In Progress", @cell))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Lynn,

Try something like this.

=COUNTIF([Project Status NEW]:[Project Status NEW]; CONTAINS("In Progress"; @cell))

The same version but with the below changes for convenience.

=COUNTIF([Project Status NEW]:[Project Status NEW], CONTAINS("In Progress", @cell))

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Lynn Meadow

Andrée thank you so much, that worked perfectly!! I really appreciate your quick response! Have a great day!

Andrée Starå

Excellent!

Happy to help!