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
|