#REF! appears when a formula still refers to a cell, row, or range that no longer exists — most often after you delete the cells it pointed at. The formula is not guessing; the reference itself is gone.
Stub
Stub
#REF! appears when a formula still refers to a cell, row, or range that no longer exists — most often after you delete the cells it pointed at. The formula is not guessing; the reference itself is gone.