i want to return value( eg;- sum) only if the source is not blank,other wise return blank !!not zero!! in excel, wps

Question

see this screenshot for reference see this screenshot..

I used SUM formula in the botton cells to get sum of all values from each row , the bottom cells display TOTAL

and i will assign the TOTAL cells in the form of "1" / "0"(on/off) !!( NOT TO DISPLAY...) using " =IF(ISBLANK(cell ID),0,1) " this type formula

Answer 1

Try this formula, this is an array formula you need to enter the formula and end with SHIFT+CTRL+ENTER

=IF(ISBLANK(A2:A6)=TRUE,"",SUM(A2:A6))