If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Insert Rows vs SUM() and SUBTOTAL()
Consider a column of numbers followed directly by a SUM() of those same
numbers. When you insert a new row between the last number and the sum() cell, the sum() cell doesn't include that new row. Not only is this a hassle, it also costs in potential missed estimations, and designs. I realize we can insert a blank thin dummy row in between, but why do we have to? Why doesn't Excel know that when you insert a row between the last in a list and the SUM of that list, of course you want to SUM the new insertion too? I can't remember ever feeling that it was good it works the way it does. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Thread Tools | |
Display Modes | |
|
|