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!
Bookmarks