dynamic - calculate sum of values dynamically using offset in Excel

Question

I have a table that looks like this

TOTAL SCORE     SPORT    Basketball   Volleyball  Football  Hockey
   14           SCORE        3            2           6       3

I want to be able to dynamically work out the SUM of the score using the OFFSET function (not excel table)

=SUM(B2:E2)

=SUM(OFFSET(B2,0,0,1,5))

both of these formulas are not dynamic as if I add an extra score or 10 new scores it cant calculate the sum of this

How can I make this dynamic

=SUM(OFFSET(B2,COUNTA(2:2),0))

THIS works however is there a more efficient way of doing this?

question from:https://stackoverflow.com/questions/65890735/calculate-sum-of-values-dynamically-using-offset-in-excel

Answer 1

Waitting for answers