REF error when deleting cells

[cherry1810]

Error #REF ! Occurs when a formula references an invalid cell, most commonly when the cell is referenced by a formula that has been deleted or pasted.




For example, in the image below, the Outcome column is referenced by the formula: = SUM (A2, B2, C2). If you delete the "Number 2" column, Excel will issue a #REF !

 

[Michael M]

Re: What is the hole? help me!

Can't see your image, but by deleting the column you have broken the sequence....A2,B2,C2.
While C2 becomes B2, there is part of the formula component missing, so it fails !!!

 

[LFKim2018]

Re: What is the hole? help me!

Error #REF ! Occurs when a formula references an invalid cell, most commonly when the cell is referenced by a formula that has been deleted or pasted.




For example, in the image below, the Outcome column is referenced by the formula: = SUM (A2, B2, C2). If you delete the "Number 2" column, Excel will issue a #REF !

try using the IF function:
example.. =IF(sum(A2,B2,C2)>0,sum(A2,B2,C2),"")
HTH

 

[LFKim2018]

Re: What is the hole? help me!

try using the IF function:
example.. =IF(sum(A2,B2,C2)>0,sum(A2,B2,C2),"")
HTH

SO SORRY,
I think the above will not work either....

try this instead:
=IFERROR(SUM(A2,B2,C2),0)
HTH