The Data SubTotals feature might be what you're looking for....


Vaya con Dios,
Chuck, CABGx3



"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.