excel.365 if column D="text" and column O=positive number then sum

[copperwasher]

Hi there Excel guru's

I have a report which is pasted into a spreadsheet (image attached)
The cells have been set to the appropriate setting

Column D contains either
buy
sell
balance

Column O
positive numbers
negative numbers

At the top of the pasted sheet I have summary calcs
I have the totals for the buy and sell values using =sumif(D7:D15000,"buy",o7 : O15000) and sell respectively

I am looking to "sum" the following individually
buy negative numbers
buy positive numbers
and
sell negative numbers
sell positive numbers

I have attempted the solution using:
1. =SUMIFS(D7:D15000,O7:O15000,"buy"&F1&">0") This fails and produces 0
2. =SUMPRODUCT(--((ISNUMBER(SEARCH("buy",D7:D15000)))>0),O7:O15000) this also fails and produces -10879. which is odd as the calc contains >0

As always, your help and guidance is much appreciated

Copperwasher

 

[jasonb75]

Sumifs will work if written correctly.

=SUMIFS(O7:O15000,D7:D15000,"buy",O7:O15000,">0")

 

[copperwasher]

Sumifs will work if written correctly.

=SUMIFS(O7:O15000,D7:D15000,"buy",O7:O15000,">0")

Jasonb75... that works perfectly.

I did look at sumifs... but didn't arrive at your suggestion
Lessons learned

Thank you