In addition to what Bernard suggested, a Pivot Table will also provide
this information.

--JP

On Oct 14, 12:52*pm, Labkhand
wrote:
I need help Suming up Amount column based on values of three different
columns. *

Let's say I have the following Detail Data:

Month * Institute * * * * * * * * * *Account Type * * * Amount *Memo
1/1/2008 * * * *Bank of America Checking * * * * * * * * * * * * *500 * Deposit
1/1/2008 * * * *Bank of America Checking * * * * * * * * * *-200 * * * *Check #111
1/1/2008 * * * *Bank of America Saving * * * * * * * * * 400 * *Deposit
1/1/2008 * * * *Bank of America Saving * * * * * * * * * 150 * *Deposit
1/1/2008 * * * *CitiBank * * * * * * * * * * * *Checking * * * * * * * * * * * * 50 * * Deposit
1/1/2008 * * * *CitiBank * * * * * * * * * * * *Saving * * * * * * * * * 100 * *Deposit

How can I SUM the AMOUNT column based on the unique values in the Month,
Institute, and Account Type columns?

The Summary result I am hoping for is:

Month * Institute * * * * * * * * *Account Type * * * Balance
1/1/2008 * * * *Bank of America * *Checking * * * * * 300
* * * * * * * * * * * * * *Saving * * * * * * 550
1/1/2008 * * * *CitiBank * * * * * * * * * Checking * * * * * 50
* * * * * * * * * * * * * *Saving * * * * * * 100

I have been trying to resolve this issue and I am stuck! *Any help would be
highly appreciated.

Thanks in advance