setting a formula that will sum at the end of data
 

I hope this makes sense -

I have a worksheet where data is imported daily, therefore the size of the
spread sheet will vary from day to day. There are certain "fee" columns that
will change, daily - meaning the amt. of data. Can I set a formula up for a
certain column that will start at say, F4 every time, and give a total
automatically when it reaches the end of the data?

THANKS!!!!

setting a formula that will sum at the end of data
 

you can put this formula

=sum(F4:FF65535) in the last cell of your data this will give the sum of the
values in col F.

=sum(F:F) you can also use this but make sure there is no formula in the
referred col since it will form a circular reference in that case.
--
_______________________
Click "Yes" button if it helps
________
Thanks
Suleman Peerzade


"AllieR" wrote:

I hope this makes sense -

I have a worksheet where data is imported daily, therefore the size of the
spread sheet will vary from day to day. There are certain "fee" columns that
will change, daily - meaning the amt. of data. Can I set a formula up for a
certain column that will start at say, F4 every time, and give a total
automatically when it reaches the end of the data?

THANKS!!!!

setting a formula that will sum at the end of data
 

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