How to return blank instead of zero?

[CHillFL]

I'm working in a spreadsheet and using this formula. It returns a 0.00 if there is no data available. How do I make it return a blank field if there is no data available?

=SUMIFS(Data!$E:$E,Data!$C:$C,'CG Template'!$B6,Data!$D:$D,'CG Template'!$F6,Data!$A:$A,'CG Template'!K$4,Data!$B:$B,'CG Template'!$G$3)

Thanks

[Glenn Kennedy]

One way: =if(yourformula=0,"",yourformula)

[Jonmo1]

The easiest way is probably to go to File - Options - Advanced and Uncheck "Show a zero in cells that have zero value"

But you can do it in the formula too if you like

Try
=IFERROR(1/(1/SUMIFS(Data!$E:$E,Data!$C:$C,'CG Template'!$B6,Data!$D:$D,'CG Template'!$F6,Data!$A:$A,'CG Template'!K$4,Data!$B:$B,'CG Template'!$G$3)),"")

[shg]

=iferror(1/(1/SUMIFS(...)), "")

... or custom-format the cell as 0;;

[CHillFL]

Awesome-sauce guys! Thank you so very much!

[Jonmo1]

You're welcome.

[Tony Valko]

Awesome-sauce guys!

Lisa? ------

[CHillFL]

Lisa? no, Carol