what function to let me create summarized spreadsheet from databas

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.
 
N

nidabland

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.
 
G

Glenn

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create new table from Multiple Criteria in multiple columns 4
What should formula look like to define date range on SUMIF 2
Collate data from one spreadsheet into another spreadsheet 2
Trying to create custom labels from an csv file + Need items numerically counted out 0
Creating new worksheets 1
Two Totals from the same column 2
Problem with MS Word paragraph and character styles: format getting messed up 2
Automatically update spreadsheet from another spreadsheet 3

Top