Importance score calculation

Hi,

I have three columns in my sheet namely A, B and Importance, Column A and B contains either + , - or S values. The Importance columns contains a value of either 1, 2 or 3.

I want to calculate the total +, total - and total S for each column after multiplying each value (+,-,S) with the imporatance value (1,2,3), so that (+)*(2) = ++. I have done this manually to show the results; but i want to automize it as i have a lot of data.

A B Importance

+ - 1
- + 2
S + 3
+ - 3
+ S 2

Total + 6 5
Total - 2 4
Total S 3 2

Pl. see attachment for better picture

Can anyone tell me if it can be done in Excel

Images are of very limited use - post a sample file.

Re: your sample - why is D2 1 and D5 3 given B & C are the same for both rows ?

The importance values are only hypothetical values and they are 'critiria' (column A)

If I've understood

Please Login or Register  to view this content.

Thanks a lot and yes you understood it correctly

No problem. Please do not quote prior posts in their entirety - this clutters your thread and the board in general.