setting a formula that will sum at the end of data

A

AllieR

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!!!!
 
S

Suleman Peerzade

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
 
J

JBeaucaire

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 tim
you import it

In another cell, below F1000 or in another column altogether, just us
the formula

*=SUM(ColumnF

*BTW, if 1000 rows isn't enough, adjust all the references to a rang
that will be sufficient
 
Top