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