ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   seperat.buys from sells.on spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/89694-seperat-buys-sells-spreadsheet.html)

johnny

seperat.buys from sells.on spreadsheet
 
seperating.buys from sells.formular.

Ardus Petus

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.




Tom Ogilvy

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