=IF(SUMIF($H18,">0")=0,"",SUMIF($H18,">0"))
=IF($H18>0,$H18,"")
=IF($H18<0,$H18*-1,"")
=MAX($H18,0)
=MIN($H18,0)*-1
Amazing, thank youActually, in looking at this closer, I failed to notice you are only checking one cell at a time. So you do not need SUMIF. That is typically used for multi-cell ranges.
So instead of this:
you can just us this:Excel Formula:=IF(SUMIF($H18,">0")=0,"",SUMIF($H18,">0"))
Excel Formula:=IF($H18>0,$H18,"")
Then for your other column, just use the same logic, but multiply by -1, i.e.
Excel Formula:=IF($H18<0,$H18*-1,"")