How to apply a weighting

H

Homer J

I'm trying to apply a weighting to my teams to allow for experience and
size

I have 3 teams which are different sizes and are different skill
levels.
Level 5 is the lowest skill level and level 1 being the highest skill
level.

Team size/level5/level4/level3/level2/level1

6/3/2/0/1/0
10/2/3/4/0/1
7/0/2/3/1/1

How do I apply a weighting to these numbers to allow for team size and
experience. Can I do this using sumproduct? I tried looking at this but
cant get my fragile little mind around it

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Child Timelines to Multiple Parents 0
How to change font & size of (all) citation numbers? 7
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Percentage doesn't add up 6
HOW-TO make a random selection from a set of data and divide it into sub-team 2
Applying a weighting to results. 6
Adding Percentages 0
Subtracting Values from a Ranked List 7

Top