Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Tab 1 of my spreadsheet, I have the following data
A-Bank Name B-Fund Type C-Amount D-Maturity Date 1 ABC Bank MMF $1,000 03/05/09 2 BCD Bank MMF $500 03/05/09 3 ABC Bank Comm Paper $2,000 03/10/09 4 ABC Bank Treasury Fund $600 03/05/09 On Tab 2, I'd like to have a formula that will provide me the Fund Type and Sum of the amounts held by bank based on their maturity date... For example...on Tab 2....I'd like to have: ABC Bank 03/05/09 (maturity date) MMF & Treasury Fund $1,600 I'd like to fill in the bank name and Maturity date fields...but would like a formula that will list the fund descriptions together "MMF & Treasury Fund"....as well as add the amounts together. I can't seem to get an Index or Match function to work...and don't want to use the Filter function since they are on seperate tabs. Any help would be appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup with Multiple results | Excel Worksheet Functions | |||
single lookup value with multiple results | Excel Worksheet Functions | |||
Lookup multiple results with gaps | Excel Worksheet Functions | |||
Lookup with multiple results, without duplicates | Excel Worksheet Functions | |||
How can I do a lookup and get multiple row results? | Excel Worksheet Functions |