[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