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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!