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

 

[Michael M]

On the home tab>>Number menu>>In the dropdown box change to either number OR General

 

[Kiwi den]

On the home tab>>Number menu>>In the dropdown box change to either number OR General

This will either give me a 0 or $
I want the cell to be totally blank

 

[sandy666]

you can try: =IF(D1:D29="","",SUM(D1:D29)) with CSE

 

[Kiwi den]

you can try: =IF(D1:D29="","",SUM(D1:D29)) with CSE

CSE?

 

[sandy666]

CSE = Control+Shift+Enter (as an array formula) instead of just Enter

 

[Kiwi den]

CSE?

OK I got CSE now when I enter values into cells D1 : D29, cell D30 does not total

 

[sandy666]

do you see curly brackets { } around your formula?

don't add these brackets manually, it doesn;t work

 

[HappierThan]

In D30 right-click<Format Cells<Number<Custom and put in $#,##0;; Now you won't have $0 displayed without any data in the SUM formula.

Just re-read your post, did you mean ALL values between D1:D29?

 

[Kiwi den]

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