How to sum numbers with multiple criteria

onmine

New Member
Joined
Apr 16, 2017
Messages
1
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

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
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
 

Forum statistics

Threads
1,077,977
Messages
5,337,509
Members
399,154
Latest member
gavlink

Some videos you may like

This Week's Hot Topics

Top