How to apply a weighting
 

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.


--
Homer J
------------------------------------------------------------------------
Homer J's Profile: http://www.excelforum.com/member.php...o&userid=26166
View this thread: http://www.excelforum.com/showthread...hreadid=395259