Dear experts,
I'm working as an economist and a week ago I had a task that I couldn't solve.
I'll be very happy if you could help me with this.
I have a ONE column with prices: some of them are in Dollar, some of them are in Euro ( like 600 lines).
I should sum separately dollar total sum and separately Euro total sum.
I don't know how to do it!
I thought about function "sumif", but I don't know how to determine the true or false that on current square is a dollar value or Euro value.
I asked this question many IT guys, but they don't know.
All my numbers on "Currency" formatting with the symbol of dollar or euro.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I tried to work with the function LEFT to determine the symbol, but it see only the number.<o></o>
<o> </o>
I really don't want to sum this numbers one by one, but if I not find the solve this time, please advise me how should I format the number (without adding columns) next time.<o></o>
<o> </o>
Thanks a lot.<o></o>
Diagea
I'm working as an economist and a week ago I had a task that I couldn't solve.
I'll be very happy if you could help me with this.
I have a ONE column with prices: some of them are in Dollar, some of them are in Euro ( like 600 lines).
I should sum separately dollar total sum and separately Euro total sum.
I don't know how to do it!
I thought about function "sumif", but I don't know how to determine the true or false that on current square is a dollar value or Euro value.
I asked this question many IT guys, but they don't know.
All my numbers on "Currency" formatting with the symbol of dollar or euro.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>I tried to work with the function LEFT to determine the symbol, but it see only the number.<o
></o><o
> </o>I really don't want to sum this numbers one by one, but if I not find the solve this time, please advise me how should I format the number (without adding columns) next time.<o
></o><o
> </o>Thanks a lot.<o
></o>Diagea
