Sum with Offset Function

[vijay.vizzu]

Dear All,


I am not familar with Offset function. I need your help in some summing calculation.


I have some monthly data from U3:AF3. Now i want to sum that, if i will input in T Column as 4, then it should sum the values from Apr to Dec, if it is 5 then sum from may to dec like that.... the result to be shown in cell AG3. any help plz....

 

[Montrey]

Enter this formula in AG3

=SUM(OFFSET($T$3,0,T3,1,1):AF3)

 

[vijay.vizzu]

Thank you so much Montrey. It works fine

 

[Montrey]

Glad I could help!