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!
Best Answer
-
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.
Answers
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!