Please help with formula

[firstWeMeet]

Hello forum, just looking for help with this formula.
I have row1 which: C1 formula is =SUM(A1+F7-G7) and I want to maintain the cell format like this

but when A1,F7,G7 has no numbers C1 showing "0" I want C1 just show blank cell when the A,F,G1 is 0 number, note that F1 and G1 has a formula too.

 

[Michael M]

The "many more" was simply a pointer to suggest you list all the cells.
Use the formula bar to highlight the cells you want to sum and maybe pick them up in groups, eg.
consider

=IF(AF1>0, SUM(A1:G1,I1:K1,N1:Q1))

 

[firstWeMeet]

i.e, ROW1 A1 to J1 then K1 has the formula =IF(K1>0,SUM(A1,C1,E1,G1,I1),"") thats the formula I set, its a circular error. note that A1 to J1 has the possibility to increase from a multiple cells.

 

[truskawa]

have you tried it the way I wrote it?
It is designed to avoid circular reference

Regarding the picking of cells you can try to put them in groups but if it is like every other cell e.g.: A1, B1, D1, G1 etc and like 100 of them. I mark them somehow e.g. put 1 is some row that you are using in column you wish to add to your reference and write macro to concatenate those adresses that contain 1 in row specified. This way you will get this list little bit easier.
If you are not familiar with VBA it just leaves you with picking cell by clicking on them. I can't se any other solution.

 

[firstWeMeet]

Truskawa, yes I tried it already, and its working, but I am in the table and the formula will be long like this.
=Table1[[#This Row],[Unit Price]],Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]]Table1[[#This Row],[Unit Price]], and many more, just a sample only.