sum cells starting from cell1 value to cell2 value

[[email protected]]

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

[FDibbins]

Assume cell1 = A1 and cell2 = B1, something like this...

=sum(indirect("F"&A1&":F"&B1)

[[email protected]]

it workes, thank you
this is an other solution
=SUM(INDIRECT("F" & C1):INDIRECT("F" & C2))

[:) Sixthsense :)]

this is an other solution
=SUM(INDIRECT("F" & C1):INDIRECT("F" & C2))

Avoid the usage of Indirect() since it is Volatile

Try this...


=SUM(INDEX(F:F,A1):INDEX(F:F,A2))

[FDibbins]

Nice 1 Six

[:) Sixthsense :)]

Nice 1 Six

Thanks for the comments and rep