Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DNA
 
Posts: n/a
Default Adding Columns in Excel

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
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
Text to Columns in excel for delimited files - allow trimming opt. D. Young New Users to Excel 1 April 25th 05 05:06 PM
adding an horizontal scrollbar to columns Sam Excel Discussion (Misc queries) 1 April 7th 05 12:05 AM
How do i copy columns of data in notepad into microsoft excel? JP New Users to Excel 2 February 10th 05 09:47 PM
Perform functions on the result of adding two columns Tim Archer Excel Worksheet Functions 2 February 2nd 05 03:25 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 06:09 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"