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

@AlexM how exactly to call this formula for more than 2 range of cells ? — Musawir_ap, May 21 '21 at 16:51
@Musawir_ap you would put that in the first cell and copy/drag it over. — Scott Craner, May 21 '21 at 17:16
@Musawir_ap literally you don't have black cells in fact you want to SUM only Positive values or values greater than Zero ,,, use formula suggested by Alex or {=IF(A2:A6>0,SUM(A2:A6),"") } & finish with CTRL+SHIFT+ENTER and fill Right,,. — Rajesh Sinha, May 22 '21 at 07:02
@RajeshS don't i have any blancells? have you seen the screenshot? aren't blank cells in table literally blank cells? — Musawir_ap, May 22 '21 at 16:04
Does this answer your question? Display Blank when Referencing Blank Cell in Excel 2010 — Scott - Слава Україні, May 22 '21 at 16:23
@Musawir_ap yeah I've seen that's Y suggested the formula try once it will work for U! — Rajesh Sinha, May 23 '21 at 04:58

score 0 · Accepted Answer · answered May 24 '21 at 08:04

0

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))

answered May 24 '21 at 08:04

Lee

1 Answers1