seperat.buys from sells.on spreadsheet
seperating.buys from sells.formular.
|
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. |
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. |
All times are GMT +1. The time now is 06:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com