[gui-talk] excel formula question

don bishop w6smb at donbishop.org
Sat Sep 30 13:03:25 CDT 2006


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






More information about the gui-talk mailing list