| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
adding number only if CDN is displayed in next cell
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
adding number only if CDN is displayed in next cell
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number cell increment +1 when dragging down box | Excel Worksheet Functions | |||
| Can I make the number in one cell automatically appear elsewhere? | Excel Worksheet Functions | |||
| First Number in a Cell | Excel Worksheet Functions | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Hybrid Mode
