Cell showing $, want it to be blank

[Kiwi den]

Hi all,

I have a cell D30, this contains =sum(D1:D29) and shows a $ until values are added to D1:D29

How do I have it so the cell D30 is blank until values to D1:D29 are added?

Your help would be appreciated

 

[sandy666]

{=IF(D1:D29='","",SUM(D1:D29))}

so why it works here?

Book1
	D
1	€1.00
2	€2.00
3	€3.00
4	€4.00
5	€5.00
6	€6.00
7	€7.00
8	€8.00
9	€9.00
10	€10.00
11	€11.00
12	€12.00
13	€13.00
14	€14.00
15	€15.00
16	€16.00
17	€17.00
18	€18.00
19	€19.00
20	€20.00
21	€21.00
22	€22.00
23	€23.00
24	€24.00
25	€25.00
26	€26.00
27	€27.00
28	€28.00
29	€29.00
30	€435.00
Sheet1

Cell Formulas
Range	Formula
D30	D30	=IF(D1:D29="","",SUM(D1:D29))
Press CTRL+SHIFT+ENTER to enter array formulas.

Book1
	D
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Sheet1

Cell Formulas
Range	Formula
D30	D30	=IF(D1:D29="","",SUM(D1:D29))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[HappierThan]

" How do I have it so the cell D30 is blank until values to D1:D29 are added? " If you meant until ALL values D1:D29.
Conditional formatting for cell D30 with the formula =COUNTA(D1:D29)=29 thus as a TRUE condition the values won't appear until they are all included.