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.
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.