Please help me to sum up the numbers with the given conditions???

[iRasim]

Please help me to sum up the numbers with the given conditions??? I uploaded the sample file.What I wanted to know showed there

 

[NARAYANK991]

Hi ,

Try this :

=SUM(OFFSET($C2,,$A2-1,,$B2))

Narayan

 

[Somendra Misra]

Hi,

Another Option:

=SUM(INDEX($C2:$N2,,$A2):INDEX($C2:$N2,,($A2+$B2)-1))

Regards,

 

[iRasim]

Thanks a lot