Zero Values In Mac Numbers 10.1

[camioneur]

I'd like to leave a blank cell rather than a zero in spreadsheets that contain a "SUM" formula
I know I can use conditional formatting to hide the zero but that's not what I need.
i.e. A6 = SUM A1:A5. Surely there's an easy formula to hide the zero in A6 if there are no entries in cells A1:A5

[ToraToraTora]

in A6 put =IF(SUM(A1:A5)=0," ",SUM(A1:A5))

[camioneur]

Thanks for that and that's exactly what I thought I should do but it doesn't work for me and I don't know why!
I've copied your formula exactly though in my case the cells are H4:H8 with the results in H9 and this is it in text format that I entered in H9 IF(SUM(H4:H8)=0,"",SUM(H4:H8)) but I still get the red triangle. Any ideas what I'm doing wrong?

[ToraToraTora]

= sign before the IF, also right click and make sure the format is "general", I tried it here, should work.

[camioneur]

ThanksTora, it does work. I created another spreadsheet and tried it again and it worked immediately. The problem appears to be in the spreadsheet as it is auto-populated from another sheet and that seems to be the cause. Thanks very much for your help

[ToraToraTora]

anytime!