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