You could use defined names for the ranges or use a formula that determines
the row.
Here we are looking for a number larger than possible in column L

=SUM(INDIRECT("L2:L"&MATCH(9999999999,L:L)))

Don Guillett
SalesAid Software

"JB12" wrote in message
...
I currently have a spreadsheet that simply consists of data that I dump in
it
from another internet based application. From there I have a second
worksheet that references certain columns/rows in the first spreadsheet to
extract just the data I need. The next worksheet I have ranks the
information and then displays it in an organized fashion on a different
worksheet. The situation I am running into is that the data I extract
from
the internet based application can have a different # of rows based on the
day I pull it and my formulas only work if the # of rows on the first
sheet
are the same. For instance, if I have 700 rows today and I pull it
tomorrow
and there are 701, the 701st row is not taken into consideration when
ranking
the data and therefore my information displayed is incorrect. Is there a
way
to have my reference cells recognize there is an extra row and update all
my
formulas to account for the extra row as well??