D delta Member Mar 23, 2017 #1 i like didnot show Zero and error in giving formla show zero what is incorrect given formula =IFERROR(IF(ISBLANK(SUM(A1:A10)),"",SUM(A1:A10)),"")
i like didnot show Zero and error in giving formla show zero what is incorrect given formula =IFERROR(IF(ISBLANK(SUM(A1:A10)),"",SUM(A1:A10)),"")
V vletm Excel Ninja Mar 23, 2017 #2 two samples: 1) =SUM(A1:A10) ... and unselect 'Show zero values' then no show error nor zero 2) =IF(SUM(A1:A10)<>0;SUM(A1:A10);"") then no show error nor zero
two samples: 1) =SUM(A1:A10) ... and unselect 'Show zero values' then no show error nor zero 2) =IF(SUM(A1:A10)<>0;SUM(A1:A10);"") then no show error nor zero
Hui Excel Ninja Staff member Mar 23, 2017 #3 =SUM(A1:A10) apply a custom number format of #,##0.00;-#,##0.00;;@ The ;; part will leave the cell blank if Sum() =0
=SUM(A1:A10) apply a custom number format of #,##0.00;-#,##0.00;;@ The ;; part will leave the cell blank if Sum() =0
D delta Member Mar 24, 2017 #4 realy very nice answer, i didnot solve this probelm for many days, once agin thanks a lot.
