=SUMIF(D:D,"="&E2,C:C)-SUMIF(D:D,""&F2,C:C)

where E2 houses -50 and F2 +50.

sam158963 wrote:
I want to sum a corresponding number in column C if the cell in column D is
between + -50.