sum cells from column F , from value of cell C1 till value of C2

[alexandru barabas]

Hi

How can i sum cells from column F , depending on value from cell C1 and C2

exemple
cell1 = 3
cell2 = 6
i want to sum (F3:F6)

thank you

 

[NARAYANK991]

Hi ,

Try this :

=SUM(INDIRECT("F" & C1):INDIRECT("F" & C2))

Narayan

 

[alexandru barabas]

thank you it's perfect

 

[XOR LX]

Or, less volatile:

=SUM(INDEX(F:F,C1):INDEX(F:F,C2))

Regards