+ Reply to Thread
Results 1 to 2 of 2

Update Total and the numbers that make up that number update also.

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    13

    Update Total and the numbers that make up that number update also.

    Ok, so here's my problem.

    I work at an accounting company, every month the accountants have to enter certain fixed expenses and provisions to the system. However, the totals assigned to each account can change. Imagine this:

    Cost center 1: $50
    Cost center 2: $50
    Cost center 3: $100
    Cost center 4: $50
    Cost center 5: $100
    Cost center 6: $50

    Provision: $400


    So, evidently the $400 is the total sum of the 6 amounts assigned to each cost center, as a percentage. So for example, CC 1,2,4 and 6 has 12.5% and cost center 3 and 5 have 25% assigned.

    How can I, by changing the total ($400), update the cells above.

    So imagine $400 gets doubled to $800, I want the same percentages assigned but the amounts to change.

    Thanks and I hope you can help me, I know it's probably easy. I also have A LOT of accounts and cost centers...

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Update Total and the numbers that make up that number update also.

    With the names Cost Center 1 etc in column A and the Provision is in B8 enter this formula in B1 and copy down the column as far as needed. When the provision is changed, the amounts for each Cost Center will change accordingly.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1