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/
