Sum Based on Criteria

[insomned]

Hello Community, 

I have to add up values in a column based on a specific parameter. For example:

MARK                               15

MARK'S COMPUTER      20

JENNY                             60

JENNY'S PHONE            12

I want to create column's Mark's Total and Jenny's Total adding up the specific amounts, how do I do this? 

Thanks! 

[messi007]

@insomned,

Please see below : 

 1- RegEx to take the name

 2- Aggregate on the new column and SUM

Attached the workflow,

Hope this helps!

Regards

[Akash__on]

Use Find Replace tool and then use Summarize tool on name as grouped.

[binuacs]

@insomned