Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
This one is tricky:
I need to calc subtotals based on various information with a cell or group of cells. This is how it works: Column A has a heading of CIF (customer info). Column E has a heading for APP type (checking, savings, cd, loans, credit reserve). Column I is for a subtotal of deposits (i.e., checking + savings + cd) and Column J is for a subtotal of loans (i.e., loans + credit reserve) If a customer has 7 CIF records and within that they have 5 checking accounts, 2 savings and 1 cd, I need the deposit total for that; and 2 loans and 1 credit reserve, I need the loan total for that. Keep in mind, if the CIF number changes, do the same for the next CIF grouping. OVERALL - total deposit and loans for each group of CIF numbers. I almost have it, but it's not quite working the way I need. Thanks for any help you can provide! David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text to Columns in excel for delimited files - allow trimming opt. | New Users to Excel | |||
adding an horizontal scrollbar to columns | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
Perform functions on the result of adding two columns | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |