Lookup a row and count all the "Yes" values across multiple columns

I can do both of these functions separately without issue, but am struggling to combine them.

I have 2 sheets and would like to lookup a value from the 1st sheet on the 2nd sheet, and then return all the "yes" fields on that row from a set of 8 columns.

I can use match to lookup the value from the 1st sheet and find it in the 2nd sheet.

I can use countif to return how many "yes" values there are across the 8 columns for a specific row.

But how can i combine match with countif? I keep getting incorrect argument.

Any thoughts on this?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!