Hey all,

I need to return only negative numbers using the SUMIF function. I can't figure out how to add the second criteria needed to have the formula return only negative numbers. Here's my working formula:

=SUMIF($C$7:$C$2000,"paypal*",$D$7:$D$2000)


So I'm wanting to look up PayPal in column C and then return only the matching negative numbers found in column D. Then I'll need to modify the formula to return the positive numbers.

Thanks for your help,
Keyrookie

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/