Hi
I really stucked, and I don't know how to do this.
A friend of mine prepared worksheet. In column "A" up to 800 entries representing household appliances. In column "B" their prices in two currencies. To be exact in USD and EURO.
So he formatted prices column. For example TV 1500 $, smoothing-iron 99 EURO. and so on. So I need to sum USD values in C1, and EURO values in D1
I tried many text formulas and other formulas from MOREFUNC.XLL, but no result...
Thanks in advance.
Bookmarks