How to sum cells of a certain format in Excel?

Question

excel

Hello, I have the following column:

I want to sum rubles and dollars separately, i.e. as a result, I would like to get the following line: I
$: 499.48, ₽: 346.13
thought to use the SUMIF formula, but it compares cell values, not the format.
Thanks in advance for your reply.

Answer 1

In general, I could not find a quick solution. I solved the problem as follows: I
added another column for explicitly specifying the currency
. As a result, I got the desired row using the following formula:
If, nevertheless, someone has a solution without an additional column, then it will be interesting for me to look at it.

Answer 2

You need to use two functions together =SUMIF and =CELL("format",A1)