sum up using various fomulas including offset indirect and sum

[arifanmol]

plz help me in modifying the formula for my expected output

 

[arifanmol]

Thanks a lot for variety of answers with my formula odds that make me chuckle with satisfaction
feel obliged
i will expect your assistance soon when i come up with some other oddities of excel formulas that i may feel
reagrds

 

[pecoflyer]

Remark: Study Offset function well, will give you a lot of interesting.

But keep in mind it is a volatile function