calculating the sum sum of numbers in one cell and dividing it to two percentages

[champer]

Hello, Im making an invoice and need some help!

How can I create a formula that automatically calculates the 'Total' considering that the prices (Price 1 and Price 2) are in the same cell, separated by rows, and in a 'number/text' format (50EUR)? Also, how can this formula calculate new prices that I additionally enter (for example, if I added Price 3, Price 4, etc)?

How can I then create another formula to divide the total into two percentages, and displayed in a single cell, separated by rows? (for example, 30% and 70% as shown in the picture above)

Thank you

 

[SpillerBD]

There is no 'number/text' format. You have either numbers (includes dates and times) or text.
You really should avoid the indicated formatting because of the inherent issues and potential for failures. Take a look at some of the available templates before committing to the pictured layout.