Dynamic Sum Function (auto update sum range with row insertion just above formula - no macro)

[@querrythis]

Needed this sooooo badly. I knew OFFSET was the solution but never thought of offsetting from the total sum cell. Thank you so much.

[@basvanderzijden2239]

Thanks! This was very clear and helpful

[@ranjitmulay8089]

Thanks a lot, This is exactly what I was looking .Thanks for explaining the sum(offset) formula so clearly.

[@jatinsaluja8229]

Very Helpful