Group Columns with CountIf

[Anonymous]

Hello everyone,

Is there a way we can group multiple columns and then enforce a COUNTIFS function?

I have multiple columns that I would like to group them into one single column, and then to enforce a countif function. The columns here have a "yes" and "no" answer so it's basically the same for all.

Appreciate the help and support from you guys here! Thank you so much!

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could unpivot these columns as a single column in query editor.