[gui-talk] excel formula question

[John De Witt]

Don,

At the bottom of the column you wish to total, create a formula by pressing 
the equals key (=). Then, type the formula. The example below assumes rows 5 
through 19 in column B, but you should substitute the applicable cell 
coordinates. Include all rows below your column title cell but not the cell 
coordinates where you wish to see the answer. Example:

SUM(B5:b19)

Even if there are no numbers entered in all rows, Excel will still total all 
values inclusive of rows 5 through 19, with the result appearing in row 20.


----- Original Message ----- 
From: "don bishop" <w6smb at donbishop.org>
To: "gui-talk mailing list" <gui-talk at nfbnet.org>
Sent: Saturday, September 30, 2006 2:03 PM
Subject: [gui-talk] excel formula question


Hi all,

We recently switched banks and I'm trying to set up a spreadsheet for all of 
our transactions.  This is quite easy since I can download the transactions 
in
.csv format and just drop them into the spreadsheet.

The one problem I have is that the downloaded transactions do not include a 
running total of the account balance.  So I need to set up a column in the
spreadsheet for this.

Can anyone tell me how to code the formula so ti will total all amounts in a 
given column regardless of the number of rows?  For example, I want to set 
up
column 7 to contain the sum of values in all rows of column 2.

I have an Excel tutorial around here somewhere but sure can't locate the CD 
at the moment.

Since this isn't probably of very wide interest, it might be well to reply 
to me privately as don't want to put the entire list to sleep.  <grin>

Thanks for any help,

Don




_______________________________________________
gui-talk mailing list
gui-talk at nfbnet.org
http://www.nfbnet.org/mailman/listinfo/gui-talk