Bill:
I have a confession to make: I'd read about the technique but had only used
it for the first time this evening.
Quite a learning venture for us both. I'm glad I could be of help. Excel is
one really great program.
Cliff
[email protected]
----- Original Message -----
From: "Bill Tipton" <[email protected]>
To: <[email protected]>
Sent: Friday, May 07, 2010 10:44 PM
Subject: Re: [Blind-Computing] Excel 2007 | Totaling - New Rows Are Added
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/
For answers to frequently asked questions about this list visit:
http://www.jaws-users.com/help/
