+ Reply to Thread
Results 1 to 4 of 4

Help with percentage of individual contribution

  1. #1
    Registered User
    Join Date
    04-08-2015
    Location
    miami
    MS-Off Ver
    MS 2010
    Posts
    2

    Help with percentage of individual contribution

    Hi!

    I need help with a formula that takes individual teams actual performance contributions to the overall team target. For example: my 20% met represents a percentage X to the overall team target of 10%. the categories listed horizontal have specific target for the whole team, the sum of the columns are not relevant for the overall performance. Column O have the team target, I need to calculate each team contribution to the overall number. Hopefully this makes sense. See attached file. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Help with percentage of individual contribution

    May be this.Pl see file.
    In P2, then drag across.

    =IF(B2="","",$O2*B2)
    Attached Files Attached Files

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Help with percentage of individual contribution

    I think this in "P2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    (This is against "Team Overal Target")

    If you need against Team Total
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    format as percentage.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Registered User
    Join Date
    04-08-2015
    Location
    miami
    MS-Off Ver
    MS 2010
    Posts
    2

    Re: Help with percentage of individual contribution

    Hi kvsrinivasamurthy! thank you for your help. the respreads of each team contribution (columns P-Z should equal the same total in column O). Your formula gets me close but still not equal. Any solutions!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 12-05-2013, 08:10 PM
  2. Replies: 1
    Last Post: 11-19-2013, 12:52 PM
  3. [SOLVED] Ranking by Percentage of Contribution to Category
    By eagle670 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-24-2013, 11:45 AM
  4. Working out staff contribution as a percentage taking into account absences?
    By highland_turkey in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2013, 09:06 PM
  5. Replies: 9
    Last Post: 05-06-2013, 04:48 AM
  6. [SOLVED] Can I calculate tax percentage deduction based on individual circumstance?
    By RAS 2112 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2013, 09:51 AM
  7. Percentage Contribution of an Account
    By Azim.Merchant in forum Excel General
    Replies: 3
    Last Post: 05-14-2012, 10:05 AM
  8. Percentage of amounts and profits of individual sales
    By lulubelleshell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2005, 03:05 PM

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