I have a list of sales for Canadian and US Customers. I marked in the column
besides the sales amount if it is CDN or US.

How can I add the CDN or the US Sales only.

Thanks for your help.