Change the refers to range

=OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B2:$B10000) ,1)

If you're going to do that, you may as well go with Dave P's suggestion of

=SUM($B$3:$B$10000) or some row number greater than you think will ever be
used.


Gord Dibben MS Excel MVP

On Sun, 2 Jul 2006 15:05:00 -0500, pelachrum
wrote:


actually one followup question...

is there a way to make the
"=OFFSET(Sheet1!$B$3,0,0,COUNTA(Sheet1!$B:$B),1 )" formula work when the
field that calculates the rest actually sits in the same column, on top,
in field B1 to be specific?