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

If this post helps click Yes
---------------
Jacob Skaria


"Johnny" wrote:

I have a count formula in cell A1 that = 25

I would like to be refer to that number in another cell reference.

For example SUM(A1:A?) where the question mark = the value in A1.

This is probably easy but I just coundn't figure it out on my own.