adding number only if CDN is displayed in next cell

E

ED

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

CLR

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


Vaya con Dios,
Chuck, CABGx3
 
Top