View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default 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!!!!