Thread: Sum returning 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default 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