seperat.buys from sells.on spreadsheet

[johnny]

seperating.buys from sells.formular.

 

[Ardus Petus]

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,

 

[Tom Ogilvy]

=sumif(A:A,"Buys",B:B)

=sumif(A:A,"Sells",B:B)