what function to let me create summarized spreadsheet from databas

  • Thread starter Thread starter nidabland
  • Start date Start date
N

nidabland

I have a database that contains a lot of bank deposits. I need to create a
new spreadsheet that will automatically add up the amounts of the deposits by
the originating bank account #.For example
Date From Acct. Amount
3/5 MS 23 500
7/8 SK 2 300
8/9 MS 23 200

I need to create a new spreadsheet that will be able to pick up the
different acct transactions and combine them into one total and automatically
update whenever I need to add a new transaction. The new spreadsheet should
look like
From Acct. Amount
MS 23 700
SK 2 300

and then if I were to add a new transaction on 8/10 to MS acct. 23 for 500,
the other spreadsheet would automatically update to 1200 without me having to
do anything. Is this possible? Sorry for the long explanation.
 
I'm sorry, but what are "criteria 1" and "criteria 2". the other problem is
that there are actually about 20 different accounts I'm trying to sum up, and
I don't know all of the account numbers, I need the formula to automatically
pick up the numbers, is this possible? thanks.
 
nidabland said:
I have a database that contains a lot of bank deposits. I need to create a
new spreadsheet that will automatically add up the amounts of the deposits by
the originating bank account #.For example
Date From Acct. Amount
3/5 MS 23 500
7/8 SK 2 300
8/9 MS 23 200

I need to create a new spreadsheet that will be able to pick up the
different acct transactions and combine them into one total and automatically
update whenever I need to add a new transaction. The new spreadsheet should
look like
From Acct. Amount
MS 23 700
SK 2 300

and then if I were to add a new transaction on 8/10 to MS acct. 23 for 500,
the other spreadsheet would automatically update to 1200 without me having to
do anything. Is this possible? Sorry for the long explanation.
Click to expand...


Look at trying a PivotTable.

http://www.ozgrid.com/Excel/excel-pivot-tables.htm

http://office.microsoft.com/en-us/excel/HA010346321033.aspx
 
Back
Top