Hi Bill, Cliff and all, In my work book I keep adding data to the top, newest closest to the top, pushing all data down. I have sections broken out by quarters where I total each quarter.
Q1 is the last section. then next up is Q2. I am currently adding data to the top for Q3. Q1 and Q2 are stable; but keep getting pushed down as I add more rows of data to the top. I have a null (EMPTY) row before each quarter break. Do you think I am safe to expect the formulas to adjust as I keep adding data to the top? Thank you, Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Gallik Sent: Friday, May 07, 2010 10:36 PM To: [email protected] Subject: Re: [Blind-Computing] Excel 2007 | Totaling - New Rows Are Added Bill, I've encountered the same problem as you. When you set up the formula -- SUM(C5:C10) -- and then insert another row ahead of Row 5 the value in the "new" C5 is not reflected in the sum. I tried this at least 4 times with the same results. Here's how I would go about doing this, I would employ a NIL cell at C4 (or C5 if there's some reason you can't use Row 4 and then use the formula - SUM(C5:C11) - and then as you insert row above Row 5 the formula will automatically adjust to increase the last cell of the formula to reflect the new row number it occupies. In other words, C11 will become C12, then C13, then C14, etc. ---- Holland's Person, Bill E-Mail: [email protected] - "With most men, unbelief in one thing springs from blind belief in another." - German Aphorist, Georg Christoph Lichtenberg (1742 - 1799) For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
