Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
Add up a column based on values in other columns | Excel Worksheet Functions | |||
Count entries in one column based on values in another column | Excel Worksheet Functions | |||
looking up values in 1 column based on 2 other columns | Excel Worksheet Functions | |||
Tallying columns based on values of 2 different columns | Excel Worksheet Functions |