Not sure what tha formula does. since that is not complete

Anway replace
'All D-Load'!$A$1:$A$4093

with

INDIRECT("'All D-Load'!$A1:A" & A1)

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


"Johnny" wrote:

Yes that helps. Could you help figure out how to adapt it into the following
formula?

SUM(INDEX(('All D-Load'!$A$1:$A$4093=$A11)

Where 4093 is the variable based on the count in cell A1 from below.

"Jacob Skaria" wrote:

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.