Thank you Mike for your help :0)

"Mike H" wrote:

Try this

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

A 5 in C1 would sum the range A1 - A5

Mike

"jimjudd" wrote:

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