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