insert list length into a function.

[o0excelnewb0o]

I have a sumif function I am using to find data on a list. I dont want to have the search the entire column, I would like the function to recognize I have added one more entry to the list (which is on another page) and increase the length by 1.

=SUM(IF('Data Entry'!A2:A37='Control Page'!K6,IF('Data Entry'!E2:E37=E2,'Data Entry'!I2:I37,0),0))

So instead of have A2:A37, I would like something like A2:A(countif(A2:A6000,">0).

 

[Domski]

Have a look at dynamic named ranges: http://support.microsoft.com/kb/830287

Dom