sum different currency comma separated cell

Not clear to me what you require: a single text string? should it be 13€, euro not 113?

Hi Jhon

I want to be like the red by section.You can see attached picture and file. In fact as you say ; one string cell with comma separeted sum values.

Thanks
Regards

For each element of accounting


=LEFT(E2,FIND(" ",E2,1)-1) &" "&VLOOKUP(RIGHT(E2,LEN(E2)-FIND(" ",E2)),$F$2:$G$5,2,0)

then concatenate

For text , simply concatenate ...

=E2&","&E3&","&E4&","&E5

at first thanks but it does not collect in this way , only concatenate.I need total grouped.

Are E8 and E9 not what you require? Same as A6 and E6

E9 is concatenation of E10 down as there is no simple way to produce the text string.

because values not total , exmple : 113 €,12 $,123 ₺,100 € >> 223 € ,12 $ , 123 ₺ > value of the euro group should be.
By the way sorry for confusion on the image. A2 and A3 is 113€ not 13€

I see now: how many currencies are you dealing with? And I assume the data initially is not in the table format you gave i.e. Currency and Text separated.

All you have to do is add the currencies to get a total for each and then use the formula provided to get the text strings.

The attached has a table which sums the currencies. The other formulae are basically the same as before.

You should now be able to construct your worksheet from the attached.

See attached sheet2: tidier version