excel - Adding multi-select values across columns

Question

I have a spreadsheet where I have a number of activities down the rows with a number of associated teams (which can be 1 to 10 in the columns)

e.g.

Activity	Team 1	Team 1 Story Count	Team 2	Team 2 Story Count	...	Team 10 Story Count
Activity 123	Team A	3	Team B	5
Activity 456	Team B	2

question from:https://stackoverflow.com/questions/65952784/adding-multi-select-values-across-columns

Answer 1

Waitting for answers