Define Sum range by using a cell reference

[jimjam]

Hi everyone,

Basically, I would like to set up a dynamic =sum formula, with where this range starts depends on the value in another cell.
Say in cell [a1] I have a value of 20.
In b1 is my forumla, which I want to sum up column c from 20 (as defined by [a1] ) to say 100.
Is it possible do do this?
thanks

 

[Richard Schollar]

Hi

=SUM(INDIRECT("C" & A1 & ":C100"))

would be one way of achieving this.

Best regards

Richard

 

[Scott Huish]

Another possibility:

=SUM(INDEX(C:C,A1):C100)

 

[jimjam]

thanks a lot guys- much appreciated