I hope I'm not over simplifying the question here, but the formula for
adding the values in, for example, Column "C", Cells 2 thru 8 is:
=SUM(C2:C8)
It doesn't much matter which cell you place this formula in, but I
personally like to enter it in the immediate previous cell (C1) or the
immediate next cell (C9) for the above sample.
Another "trick" I like to use is to reserve the final "Addend Cell" (C8 in
this example) as blank or holding the value 0. By doing this, I can readily
insert additional rows above that row holding the final addend and the
formula will automatically adjust to include the new row. Here's what I
mean (continuing with use of the "C" column):
- Place values in cells C2 - C8 with a NULL or 0 in cell C9
- in cell C10 insert the formula: "=SUM(C2:C9)
Then, if for some heretofore unknown reason, additional values are required:
- insert additional rows above "Row 9"
- note that however many rows you've inserted above "Row 9" that the formula
formerly in Cell C10 will have migrated down that number of rows
- suppose you inserted 3 new rows above the former NULL "Cell C9"
- the formula will now reside in Cell "C13"
- the formula itself will have been automatically altered to "=SUM(C2:C12)"
- and you will have created what I refer to as a "live formula" because it
will "grow" as demonstrated above
You can do similar gymnastics with other types of formula cells, but those
are certainly not quite so obvious as with addition formulas as how to do
it.
----------------
Holland's Boy, Bill
- "Of all the things I've lost, I miss my mind the most."
- unknown -- but I'm sure any one of a number of us could claim it as our
own! ;-)
-----Original Message-----
From: Tom
Sent: Saturday, September 01, 2012 3:02 PM
To: blind-computing@jaws-users.com
Subject: [Blind-Computing] adding amounts in cell columns
can anyone tell me how to find the sum of numbers in cells in a column?
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/