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.

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

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.

"Teethless mama" wrote:

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

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.


Look at trying a PivotTable.

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

http://office.microsoft.com/en-us/ex...346321033.aspx

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

"nidabland" wrote in message
...
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.