On the sheet in question, click on *INSERT NAME Define*
For the new named range *Names in Workbook, *enter _*ColumnF*_
Now in *Refers To:,* enter the following formula:
=INDEX(SHEET1!$F4:$F1000, 1):INDEX(SHEET1!$F4:$F1000,
COUNTA(SHEET1!$F4:$F1000))
Now, the name ColumnF will dynamically adjust itself the data each time
you import it.
In another cell, below F1000 or in another column altogether, just use
the formula:
*=SUM(ColumnF)
*BTW, if 1000 rows isn't enough, adjust all the references to a range
that will be sufficient.
--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile:
http://www.thecodecage.com/forumz/member.php?userid=73
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=52250