How to use SUM and OFFSET Excel functions

Want to learn Excel? Sign up for my Excel Basics course: get.tenuki.com...
This video is about Sum and Offset functions in Microsoft Excel. It shows you an example of a solution to a specific calculation problem, when you need to place a marker to determine the range of numbers that need to be added up by the SUM function.

[@kulwindersethi]

Thanks ! Solution is very useful . Keep it up.

[@goodfridienaval0409]

what about adding cells in range with constant offset value,, thank you

[@nooramin5386]

That is genius, I solute you!

[@soccerstats5531]

super helpful

[@samuelraj4134]

Thank you:)

[@gpalepoi]

what if I want to add columns before the marker x

[@csadanandancsadanandan8132]

Yes very good