Try this:

=SUM(B2:INDEX(B2:B65536,COUNT(B:B)))

Assumes no empty cells *within* the range.

Biff

wrote in message
ups.com...
I usally import data that varies in rows, sometimes it generates 1000
rows sometimes 2000 rows, again it varies. I have a forumula that
searches a range, for example, one forumula sums all the values in
B2:B10000. I set my range to 10000 because I never know how many rows
I am going to import. Is there a formula that I can use that allows
me to find the end of the data in a column?

James