| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Faz,
the OP will be simply entering the new value at the end of the column, and not inserting a new row everytime. Mangesh "Faz" wrote in message ... Yes there is a way, i just figured out how to do it myself! If you have an equation that sums an entire column like =SUM(A1:A50) and you need it to keep updating, just insert a row within the range of rows 1 to 50, and the formula will automatically update to =SUM(A1:A51) -- Faz ------------------------------------------------------------------------ Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830 View this thread: http://www.excelforum.com/showthread...hreadid=474043 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preventing NULL showing as 0 on a pivot chart using Office Web Component. | Charts and Charting in Excel | |||
| Null points in a line chart | Excel Discussion (Misc queries) | |||
| Multipying columns that contail null values | Excel Discussion (Misc queries) | |||
| Charting should not plot NULL as a zero | Charts and Charting in Excel | |||
| how to enter a null cell value in a formula | Excel Worksheet Functions | |||
Threaded Mode
