Count the amount of Failing scores across a range of columns

I am trying to count the amount of Failing scores across a range of columns based on the customer that is selected.


Currently I am able to count the amount of Failing scores for Atlanta from 1 column with this function:

=COUNTIFS({ORA: Flight Observation 1 Customer}, ="Atlanta", {ORA: Flight Observation 1 Q1 Score}, ="1. Failing")


But I would like to count the amount of failing scores across a range of columns (this is just a test but down the road I plan to have 150+ questions with possible failing scores.

I looked at doing COUNTIFS with HAS or CONTAINS but that is not working:

=COUNTIFS({ORA: Flight Observation 1 Customer}, ="Atlanta",{ORA: Flight Observation 1 Range 2} CONTAINS("1. Failing", @cell))


Any help would be helpful, thank you!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!