I've inherited a massive sheet and leadership has asked that it not be modified. There are 5 "actions" per row. I'm trying to count if any of the 5 actions are classified as "high" significance. The goal is to chart the number of "high" actions by function.
=COUNTIFS({DD Input sheet - system team function}, "franchise", {DD Input Sheet Range 1}, "High", {DD Input Sheet Range 2}, "High", {DD Input Sheet Range 3}, "high", {DD Input Sheet Range 4}, "high", {DD Input Sheet Range 5}, "high")