• 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)