Add column values including multiplications

Hello,

I've run into a small problem while making a database to keep track of some stuff .
Here's what I'm trying to accomplish:

I've got a column with values like these:

2x €15,00

1x €20,00

1x €20,00; 2x €15,00

3x €15,00

I'd like to make a cell at the bottomthat counts how many times there's 15 and how many times there's 20 total.
As in, the above example would mean 7x €15,00 and 2x €20,00.
(If the output would be just "7;2" or 2 cells with just "7", "2", that would also be fine).

If I need to split it into two columns instead of 1, that's fine, although 1 column would be preferred

I hope someone can help me with this (if it's at all possible).

Kind Regards,

Chris

deleted by tim