what function to let me create summarized spreadsheet from databas

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

 

[Teethless mama]

=SUMPRODUCT(--(B2:B100="criteria 1"),--(C2:C100="criteria 2"),D2100)

 

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

 

[Glenn]

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.

Look at trying a PivotTable.

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

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

 

[Ashish Mathur]

Hi,

Create a pivot table. Drag, date, from and acct. to the row field area and
amount to the data field area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com