Sum only selected cells

[Chetu]

Hi everyone,

I have some data for last 1 year starting from C3:C14 , I enter no. of
months in Cell C1 ( example 7) in cell C2 i want the sum of only 7
months ( entered in Cell C1), How can i achieve this.

Chetan J

 

[Charabeuh]

try this

=SUM(OFFSET(C3,0,0,C1,1))