Hi, I found many people said it's useful to use sumproduct() function. In my case, I used it as below. Very bad results Can you correct it ONLY using sumproduct() function?

=SUMPRODUCT(--(A1:A1000="High"),--(C1:C1000<0),B1:B1000/C1:C1000)

A B C
1 High 2 1
2 Low 2 2
3 High 3 2