3D Formula - Result Zero

[esgca2010]

Hello,

When I create the 3D formula it works beautifully if the other worksheets have data. If the sheets are left blank to create a template, it shows a result of 0.

I would like it blank and NO zeros.

=SUM('Sunday 9-30:Saturday 10-13'!E9)

I thank you for your continued support.

Elaine

 

[Michael M]

Try

=IF(SUM('Sunday 9-30:Saturday 10-13'!E9)=0,"",SUM('Sunday 9-30:Saturday 10-13'!E9))

 

[esgca2010]

Thank you!

I did the post because we are trying to meet a deadline, and everyone is very stressed. Really don't have time to search anywhere. If we don't meet the deadline, millions of dollars can be lost.

I'm so glad and appreciative for your support.

I have used this forum to search for answers to my questions and have been very successful.

Again, thank you!

Elaine

 

[Michael M]

glad it helped...

 

[Aladin Akyurek]

You could also use a custom format and keep the formula you have as is:

[=0]"";General