Hello! For this case, we don't really use SUMIF, but rather, we use SUMIFS.

SUMIFS is used as:

=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2...)


so for this case, just do it the same way, then just add the criteria Range, and for criteria2, assuming A2 is the cell:

A2<-1

With that, it will only add negative numbers.

You can also check this out to learn more about SUMIFS Function in Excel.

https://www.efinancialmodels.com/kno...tion-in-excel/