How to sum cells depending on their format?

Question

excel

The table contains the values
​​100 USD
200 USD
100 rubles.
USD and rub. - these are signatures that are inserted automatically. the "Currency" cell type is configured and the appropriate currency is selected.
So the actual task is to make a formula that, depending on the currency, will sum up the USD separately and the ruble separately.
Tried to do SumIf, not an option.

Answer 1

look here