How can I sum up the currency totals for each of the currency you find in the price column ? I like to be able to derive the totals for USD, the totals for HK$ and also for the Euro, so that I can know my exposure to each currency in that column. Is this possible in Numbers ? Appreciate the help here. Thanks.
MacBook Air 13″, macOS 12.3
Hi CJHENG27,
Or you could find a text / unit with TEXTBEFORE and REGEX, this will work for all units.
But as long as you have a currency it is easier to go with CURRENCYCODE as recommended by Yellowbox.
Ralf
Hi CJHENG27,
Or you could find a text / unit with TEXTBEFORE and REGEX, this will work for all units.
But as long as you have a currency it is easier to go with CURRENCYCODE as recommended by Yellowbox.
Ralf
Hi CJHENG27,
Here is one way. Extract the Currency Codes in another column.
Formula in Inventory List C2: CURRENCYCODE(B2)
Then use SUMIF in another table.
Formula in Sum by Currency B2: SUMIF(Inventory List::C,A2,Inventory List::B)
I used simple values to make it easier to check.
Regards,
Ian.
Thanks for the answer ! The function REGEX is powerful. I could now proceed to hide that Currency column and do the sums accordingly.
Fantastic ! Thanks for the answer. I didn't know obviously that the currencycode function exists and your bonus solution for me in SUMIF.
Sum of each currency that appears in a column in Currency format
