Calculate a row

[Ron_Mansolo]

Need help with calculating a row by counting the number of YES answers from columns in the same row.

[Steve]

Try something like:

SUM(
  LIST(
    IFS(("YES" = [Col1]), 1),
    IFS(("YES" = [Col2]), 1),
    ...
  )
)