| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
seperat.buys from sells.on spreadsheet
seperating.buys from sells.formular.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
seperat.buys from sells.on spreadsheet
Wow! What a precise question!
Could you give more details: I presume buys and cells are in same column. Are they positive/negative numbers? Cheers, -- AP "johnny" a écrit dans le message de news: ... seperating.buys from sells.formular. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
seperat.buys from sells.on spreadsheet
=sumif(A:A,"Buys",B:B)
=sumif(A:A,"Sells",B:B) -- Regards, Tom Ogilvy "johnny" wrote in message ... seperating.buys from sells.formular. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to handle multiple currencies with one spreadsheet | Excel Discussion (Misc queries) | |||
| Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
| Spreadsheet merging problems | Excel Worksheet Functions | |||
| Linkage data between two spreadsheet | Excel Worksheet Functions | |||
| Linking formula to external spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
