Need help with calculating a row by counting the number of YES answers from columns in the same row.
Try something like:
SUM(
LIST(
IFS(("YES" = [Col1]), 1),
IFS(("YES" = [Col2]), 1),
...
)
)
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |