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]))
Help Article Resources
Check out the Formula Handbook template!