I need a countif or sumproduct formula that can count a number of values
based on a multiple criteria.

Count range: D:D column
Criteria: Count the number of cells that are greater than 0 and less than
200 in column H:H, that also have a the word "BUY" in coulmn B:B.

Any help would be appreciated.


--
Regards,

timmulla