Search end of data in column

  • Thread starter Thread starter Mos.StaLL
  • Start date Start date
M

Mos.StaLL

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
 
Try this:

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

Assumes no empty cells *within* the range.

Biff
 
You could try something like

=sum(offset(B2,0,0,counta(B:B),1)

If you have a header in B1, it would be
=sum(offset(B2,0,0,counta(B:B)-1,1)
 
Fri, 11 May 2007 12:01:00 -0700 from Barb Reinhardt
You could try something like
=sum(offset(B2,0,0,counta(B:B),1)

If you have a header in B1, it would be
=sum(offset(B2,0,0,counta(B:B)-1,1)
Click to expand...

Barb,

Is there a variant that works when there are some empty cells within
the range?
 
Back
Top