| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh ColumnTotal
Just sum from the cell below the sum formula to the last cell of the column.
The following could be placed in cell A1. It is for xl2007. Earlier versions do not have as many rows. Note: You can't include the cell where the formula is because you would get a circular reference. =SUM(A2:A1048576) -- Regards, OssieMac "a m spock" wrote: I have a data table to which fresh rows keep getting added evry now and then. how to i put a toal at the top of a column which will refresh everytime a fresh row is added. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Excel functions formula and auto refresh refresh | Excel Worksheet Functions | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
| Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
| Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming | |||
Threaded Mode
