Count the amount of Failing scores across a range of columns

Laszlo B

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!

Paul Newcome

You will need a helper column on the source sheet that counts the number of failing scores on each row. Then you would use a SUMIFS to add up this helper column based on the Customer column.

Paul Newcome

You will need a helper column on the source sheet that counts the number of failing scores on each row. Then you would use a SUMIFS to add up this helper column based on the Customer column.