Add SUMTOTAL into one table (added from another Table for Each Same USERID add total (from rows)

Still not sure I follow, but it sounds like you need a template column that joins Challenge Name and URL Team together. Then you use a relation column to link that template to itself. Finally you can use a rollup column with that relation.