Use SUMIF()
See HELP for details

--
Kind regards,

Niek Otten

"ED" wrote in message
...
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.