Sum only negative values in a given range using SUMIF ...

In fact, you can use this function to sum all the negative or positive values in the ... and sumrange identifies the cells Excel sums when the values in range meet ...

www.techrepublic.com