Match Lookup Question

[proctk]

Lets see if I can explain this

I Have a Spreadsheet that works like a table.

Table Example

Ex SU DI
waiting Result


sales 25% 10 12 11 10
Calls 25% 100 130 130 100
Meeting 25% 13
Dollars 25% 25000 24000 23000 22000

Each column ( Ex Su DI) are given a Score 1 - 3. to calculate the total weighted result - in the above case the score would be 1*.25 + 1*.25 + 3*.25 = 1.25


I could use an IF Statement but it would get long.

I hope that his makes since
Help please

 

[Aladin Akyurek]

I think you need to elaborate: the desired results and the procedure for calculating them.