Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum formula to include new rows added
Problem:
I have a simple formula adding about 20 rows or so but my problem is that when new rows are added at the bottom, the formula doesn't pick up the new rows...is there anything I can do to have the fomula automatically pick up those cells without having to check formulas all the time? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum formula to include new rows added
Hi,
Convert the range to a list by Data List Create a List. Please ensure that there are no blank rows. Once you convert the range to a list, it become auto-expanding -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "desperateforanswers" wrote in message ... Problem: I have a simple formula adding about 20 rows or so but my problem is that when new rows are added at the bottom, the formula doesn't pick up the new rows...is there anything I can do to have the fomula automatically pick up those cells without having to check formulas all the time? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum formula to include new rows added
Supose you have a formula like:
=SUM(A1:A20) If you insert a new row 15, for example, then the formula will automatically adjust to: =SUM(A1:A21) However, if you just enter a new value at the bottom of the range in cell A22, the formula will not adjust. You could have this as your formula: =SUM(A;A) then it will not matter if you insert a row or just add numbers to the bottom of your existing list - this will add all numbers in column A, wherever they are. Hope this helps. Pete On Nov 6, 5:24*am, desperateforanswers wrote: Problem: I have a simple formula adding about 20 rows or so but my problem is that when new rows are added at the bottom, the formula doesn't pick up the new rows...is there anything I can do to have the fomula automatically pick up those cells without having to check formulas all the time? * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preserving hyperlinks when rows are added | Excel Discussion (Misc queries) | |||
How do I enter a formula that will update as more rows are added? | Excel Worksheet Functions | |||
Identify New Added Rows | Excel Worksheet Functions | |||
Rows added after refresh not in formula | Excel Worksheet Functions | |||
Can inserted rows automatically include existing worksheet formula | Excel Discussion (Misc queries) |