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


"nidabland" wrote:

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.