Sum based on multiple field names

[limats]

Hi I'm sure a simple question sorry;

I have in my workflow up to this point;

Date	Product	Names	Location	Amount
2021	Laptops	Dell	UK	100
2021	Laptops	Lenovo	HK	200
2021	Laptops	HP	US	300
2021	Laptops	HP	US	400
2021	Laptops	Lenovo	HK	500
2021	Laptops	Dell	US	600
2021	Laptops	Dell	UK	700

I am trying to sum based on Names and Location so it would look like this

Date	Product	Names	Location	Amount
2021	Laptops	Dell	UK	800
2021	Laptops	Lenovo	HK	700
2021	Laptops	HP	US	700
2021	Laptops	Dell	US	600

Please can someone advise? 

Thanks,

Matt

[messi007 · Accepted solution]

@limats,

Please see below:

Attached the workflow,

Hope this helps,

Regards

[grazitti_sapna · Accepted solution]

Hi @limats , you can use summarize tool with the following configuration.

I hope this helps, kindly mark this post as solution.

Thanks.

[limats]

Thank you I was being silly - Friday afternoon..

[limats]

Thank you!