Calculate a row

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),
    ...
  )
)
2 Likes