LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 42
Default How can SUM a column based on values of other columns?

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding numerical values based on multiple values in another column Kazmaniac Excel Worksheet Functions 6 April 4th 07 08:53 PM
Add up a column based on values in other columns Jay[_2_] Excel Worksheet Functions 5 February 17th 07 01:02 AM
Count entries in one column based on values in another column Kurt Excel Worksheet Functions 7 January 10th 07 09:29 PM
looking up values in 1 column based on 2 other columns CMO Excel Worksheet Functions 5 August 8th 06 02:41 PM
Tallying columns based on values of 2 different columns Mctabish Excel Worksheet Functions 1 January 30th 05 10:40 AM


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"