Formula with references on base with cell values.

[flaviu123]

Hi !
How can I write a formula in Excel with cell values references? Example:
A1 = 7
A2 = 15
How do I write = SUM (C7: C15) with the values ​​of A1 and A2?

Thanks!

 

[flaviu123]

I found the meantime: =SUM(INDIRECT("C" & A1 & ":" & "C" & A2))