Hi everyone,
I have a spreetsheet with one column which requests user to input their
amount. User wants to input ###us as us amount and without us as can amount.
Since that spreadsheet is too wide, they don't want to split this into two
column, but they want to summary them by currency, how
would I do this?
for example:

100
us100
100
us100

in one column
how can I sum us=200, can=200?

Thanks,
sarah