Sum returning 0
 

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

Sum returning 0
 

FormatCellsNumberCustom. In the Type box, enter

#;-#;-

--
Kind regards,

Niek Otten

"JR" wrote in message
...
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

Sum returning 0
 

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

"Niek Otten" wrote:

FormatCellsNumberCustom. In the Type box, enter

#;-#;-

--
Kind regards,

Niek Otten

"JR" wrote in message
...
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

Sum returning 0
 

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

--
Kind regards,

Niek Otten


"JR" wrote in message
...
Thanks for the reply. Is there a formula I can use instead?

"Niek Otten" wrote:

FormatCellsNumberCustom. In the Type box, enter

#;-#;-

--
Kind regards,

Niek Otten

"JR" wrote in message
...
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

Sum returning 0
 

thanks

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten


"JR" wrote in message
...
Thanks for the reply. Is there a formula I can use instead?

"Niek Otten" wrote:

FormatCellsNumberCustom. In the Type box, enter

#;-#;-

--
Kind regards,

Niek Otten

"JR" wrote in message
...
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