Vlookup or index match for repetitive names in the range

Hi guys

i want to sort the data mentioned below

15829458 81,078.00 Zara
15829459 5,153.75 Jumani
19163645 7,001.00 Milo
19163633 2,775.00 Zara
19163637 24,423.00 Milo
19163646 312,542.00 Nestle
19163648 62,747.00 Zara Fertilizer
19163651 2,032.00 Zara Fertilizer
19163628 314,448.00 Nestle

so that total values of Zara would appear ( 81078+2775) against the box zara and like wise for other names. However iam not able to use index match or V look up for it as they show N/A beacuse the range contains repetitive names

Can anyone help me on this please

Are you looking to actually sum the numbers up?

If yes try:

=SUMIF(C:C,"Zara",B:B)

OR:

=SUMIF(C:C,"C1",B:B)

If not and you're looking to have a Cell display their value split with + sign I won't be able to advise.