Result a blank cell

[EmmaTM]

Hi,
I am using the following formula in columns E&F:
=(SUMIF($H18,">0"))

But if it results zero I want the cell to remain blank, how do I do this?

Thank you

 

[Joe4]

One way:

=IF(SUMIF($H18,">0")=0,"",SUMIF($H18,">0"))

 

[EmmaTM]

Thank you, that worked perfectly for column E.
I used the same in column F and swapped > for <
=IF(SUMIF($H18,"<0")=0,"",SUMIF($H18,"<0")) but I want the numbers in column F to be positive as the previous screenshot. So F18 should be 9,590.63 not -9,590.63.

thank you

 

[Joe4]

Actually, 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:

=IF(SUMIF($H18,">0")=0,"",SUMIF($H18,">0"))

you can just us this:

=IF($H18>0,$H18,"")

Then for your other column, just use the same logic, but multiply by -1, i.e.

=IF($H18<0,$H18*-1,"")

 

[Joe4]

Another option still:

You can use a simpler formula, i.e.
for column E:

=MAX($H18,0)

for column F:

=MIN($H18,0)*-1

and then simply apply the following Custom Number format to columns E and F to hide the zeroes:
0;-0;;@

If you aren't sure how to do that last part, check out the "Hide zero values in selected cells" section here: Display or hide zero values

 

[EmmaTM]

Actually, 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:

=IF(SUMIF($H18,">0")=0,"",SUMIF($H18,">0"))

you can just us this:

=IF($H18>0,$H18,"")

Then for your other column, just use the same logic, but multiply by -1, i.e.

=IF($H18<0,$H18*-1,"")

Amazing, thank you

 

[Joe4]

You are welcome.