adding number only if CDN is displayed in next cell

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.

Use SUMIF()
See HELP for details

--
Kind regards,

Niek Otten

"ED" <[email protected]> wrote in message
news:[email protected]...
>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.

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


Vaya con Dios,
Chuck, CABGx3



"ED" <[email protected]> wrote in message
news:[email protected]...
> 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.