Ref#

[afdmello]

I have a cell in a excel sheet which displays in the formula bar
=Sum (ref#) but is actually summing and giving the result in the cell


What can be result of this

K2 = sum(ref#) which in reality should be sum(k4:K16)

Afd

 

[Robert Mika]

It may happen when you have Automatic calucaltion switch off and you have deleted some columns.
See below

This "formula" used to point to C1:E1

 

[afdmello]

I checked automatic caculation is not switched off.
How do I remove the Ref# in the sum formula.

Apply the formula again?

Afd

 

[Robert Mika]

Yes thar the only way- to reasign the ranges the formula was poining to before.