Sum returning 0

[Guest]

Hello,

When using:

=SUM(BB31,BD31,BF31,BH31,BJ31,BL31,BN31,BP31,BR31,BT31)

If hte cells are blank I get a 0 (zero). How can I write this formula so if
the cells are blank I get a - (dash)?

Thanks

 

[Niek Otten]

Format>Cells>Number>Custom. In the Type box, enter

#;-#;-

 

[Guest]

Thanks for the reply. Is there a formula I can use instead?

 

[Niek Otten]

=IF(SUM(BB31,BD31,BF31,BH31,BJ31,BL31,BN31,BP31,BR31,BT31)=0,"-",SUM(BB31,BD31,BF31,BH31,BJ31,BL31,BN31,BP31,BR31,BT31))

 

[Guest]

thanks

=IF(SUM(BB31,BD31,BF31,BH31,BJ31,BL31,BN31,BP31,BR31,BT31)=0,"-",SUM(BB31,BD31,BF31,BH31,BJ31,BL31,BN31,BP31,BR31,BT31))