Been trying to get this for a while lol.

I have got the SUMIf of data to only display 0 if its negative.

Now I'm looking to subtract a value from it But retain the if negative only display 0

=SUMIF(G38:G44;">0")

so far this works to only display 0 if negative. But I'm looking to use the sum and subtract from a different cell.

=F41-SUMIF(G38:G44;">0") which this works just doesn't retain the ">0"

Have tried a few variations of this as well as a few formatting options but still getting me an error so I thought since I'm looking on the forum for an answer why not ask.

so thanks in advance for the help

RusselB thanks for that solution

=max(0;sumif(G38:G44;">0")-F41)