Use a vlue of a cell for the sum range

[jimjudd]

I want to use value stored in a cell (lets say C1) to use for SUM function
range.
For example SUM(A1:AC1)
C1 bing a value stored in cell C1, may be 5

 

[Mike H]

Try this

=SUM(INDIRECT("A1:A"&C1))

A 5 in C1 would sum the range A1 - A5

Mike

 

[jimjudd]

Thank you Mike for your help :0)

Try this

=SUM(INDIRECT("A1:A"&C1))

A 5 in C1 would sum the range A1 - A5

Mike