Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cancelling getpivot formula when setting formula outside pivot ta. | Excel Worksheet Functions | |||
VBA setting formula for a cell causes "Wrong data type" error | Excel Discussion (Misc queries) | |||
Setting hover data labels to cells other than source data | Charts and Charting in Excel | |||
Setting hover data labels to cells other than source data | Excel Discussion (Misc queries) | |||
Re-setting lat row or end of data | Excel Discussion (Misc queries) |