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