Hi Cliff, It adjusted my formula as I inserted rows above my column I was totaling. I must have done something incorrectly the first time I inserted new rows.
Thank you, Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Cliff Smales Sent: Friday, May 07, 2010 7:13 PM To: [email protected] Subject: Re: [Blind-Computing] Excel 2007 | Totaling - New Rows Are Added Hello, Bill: I don't use the same excel program as you, but I think the method is the same. To total a row of cells, write thefollowing formula: =Sum(c10:c15) The addition of additional cells, rows, and so on, comes under your "Insert option" Cliff Smales ----- Original Message ----- From: "Bill Tipton" <[email protected]> To: <[email protected]> Sent: Friday, May 07, 2010 8:34 PM Subject: [Blind-Computing] Excel 2007 | Totaling - New Rows Are Added > Hi, > > How can I total a group of cells in one column, c10:c15) and be able to > insert new rows above row 10 and not affect my formulas. > > When I insert new rows, my formula does not change when the group of > cells gets pushed down and the cell number changes. I would > like it to adjust as I add new rows to the top of the spreadsheet. > > I am using the formula, > =sum(c10:c15) > Is there another formula I can use that adjusts after I have initially set > it? > > I am using Excel 2007 and JAWS 11. > > Thank you, > > Bill > > > 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/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
