Formula returning zero rather than blank as needed

[pedro-egoli]

This formula returns a zero

=IF(B6="","",SUMIF(F6:I6,">0"))

B6 is a date and if there are no positive figures in cells F6:I6 i need cell to be blank rather than show a "0" as at present.

Any help appreciated

Pedro

 

[AlphaFrog]

Try something like this...

=IF(OR(B6="",MAX(F6:I6)<=0),"",SUMIF(F6:I6,">0"))

 

[pedro-egoli]

Thanks for that works perfectly.

Was just poking around and found Tools/options /untick zero values removed the zero's too.

Does this latter option have any downside?

Pedro

 

[tv9_rohith]

even you can use this - =IFERROR(IF(B6="","",SUMIF(F6:I6,">0")),"")

 

[AlphaFrog]

Was just poking around and found Tools/options /untick zero values removed the zero's too

Does this latter option have any downside?

None I can think of.

 

[T. Valko]

Was just poking around and found Tools/options /untick zero values removed the zero's too.

Does this latter option have any downside?

Pedro

That setting will apply to the ENTIRE sheet.

Just so you remember that a cell might contain a number 0 but you just don't see it.

 

[pedro-egoli]

TV9, That one still returned a zero.

TValko, I see what you mean.
It loioks like Alpha Frog's suggestion is the best option

Thanksto all
Pedro

 

[T. Valko]

TV9, That one still returned a zero.

TValko, I see what you mean.
It loioks like Alpha Frog's suggestion is the best option

Thanksto all
Pedro

You're welcome. We appreciate the feedback!