Sum only selected cells
 

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

Sum only selected cells
 

try this

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



"Chetu" a écrit dans le message de
...
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