| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to summarize data and deduct on second sheet? (Formula)
-- Hi again, Let us say SHEET 1 is the input sheet that is based on date. SHEET 2 contains list of Accounts with corresponding credit limit. In SHEET 2 B1 is account name, C1 is credit limit, D1 is Outstanding Balance, E1 is credit limit net of outstanding balance. How does D1 view all that is encoded in SHEET 1 Recognizes account name and outstanding balance adding it all up before E1 can deduct from credit limit to get credit limit for net balance credit limit. joromajr |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summarize information on another sheet | Excel Worksheet Functions | |||
| Need help creating a formula to summarize data! | Excel Worksheet Functions | |||
| summarize data sheet | Excel Worksheet Functions | |||
| Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
| Summarize multiple worksheet detail on summary sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
