How to sum numbers with multiple criteria

[onmine]

Hi,
I'm trying to sum numbers with multiple criteria.

To prevent the number of columns from increasing,
I've written the information in one cell.


Column1 Column2
Project1 P3(2)
Project2 P6(4)
Project3 L5(2)

Then, I want to sum numbers
(1)seperating the numbers in parentheses from the numbers outside, andd
(2)depending on wht the preceding letter(P/L/F) is.

The results I want are shown below.

Column1 Column2
Project1 P3(2)
Project2 P6(4)
Project3 L5(2)
P(Goal) 9
P(Performance) 6
L(Goal) 5
L(Performance) 2


Please help me make vba code for this work.

 

[FDibbins]

Any time you combine numbers and text, you end up with text, not a number/value, and you cannot add text. I suggest that you try and slip the numbers from the text, and then run your calcs based on that