Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
1.0k views
Welcome To Ask or Share your Answers For Others

1 Answer

Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...