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 |
---|---|
43 | |
29 | |
29 | |
14 | |
14 |