Sum only negative numbers in the Sum Range of the SUMIF function
From
MyVeryOwnSelf@21:1/5 to
All on Thu Mar 19 16:11:42 2020
Something like this might help:
For the negatives
=SUMIFS($C$7:$C$2000, $D$7:$D$2000, "paypal*", $C$7:$C$2000, "<0")
For the positives
=SUMIFS($C$7:$C$2000, $D$7:$D$2000, "paypal*", $C$7:$C$2000, ">0")
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)