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,
--
AP

"johnny" <johnny@discussions.microsoft.com> a écrit dans le message de news:
EE15CA6C-D41D-4F6F-B6A9-15E74CEDCDF7@microsoft.com...
> seperating.buys from sells.formular.

[Tom Ogilvy]

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

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

--
Regards,
Tom Ogilvy

"johnny" <johnny@discussions.microsoft.com> wrote in message
news:EE15CA6C-D41D-4F6F-B6A9-15E74CEDCDF7@microsoft.com...
> seperating.buys from sells.formular.