Trying to calculate a countif and contains a "city"

Roshni Verappan

Hi

I have a sheet that is filled out by staff and another sheet that has a breakdown of % compete for each branch.

The requirement is to calculate how many power users from Calgary have completed the checklist There are 10 members in a Calgary need to find the percent that have completed the power user training.

Was trying this formula:

=COUNTIFS({Wave 6A- Acturis Readiness}, =true) / [Team Members in Group]@row, CONTAINS(Branch1@row,"Calgary")

Any assistance is appreciated.

Kelly Moore

Hey @Roshni Verappan

To better answer, it would be helpful to have more details.

Is it possible to get a screenshot of the relevant columns of your source sheet? Specifically, does the source sheet reference the Branch? What does the checkbox in the source sheet signify (referenced in your COUNTIFS)?

What do the 10 team members of Calvary represent? Power users?

Kelly

Roshni Verappan

Hey Kelly,

Thanks for the quick response but I managed to figure out a formula that worked.