identify currency and do sum

  • Thread starter Thread starter sg
  • Start date Start date
S

sg

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
 
=SUM(IF(LEFT(A1:A100,2)="us",--RIGHT(A1:A100,3)))

entered with Ctrl + Shift + Enter since this is an array formula

for the canadian

=Sum(A1:A100)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Identify currency and do sum 7
Sum based on mulitple criteria and show indicator 2
Summing based on currency format of Cell 2
Conversion from columnwise to rowwise 6
Change currency on all sheets based on one cell value 3
Two Totals from the same column 2
Identifying currencies 7
Removing a leading space in a numbered currency cell 5

Back
Top