SOLVED
Home

Excel cell error

Carlos2750
Occasional Contributor
I have a row of cells containing numbers when filled in. Cells 2 and 3 are added together to produce a sum in the 4th cell, which works fine with no errors, but when I add a number to the 1st cell (not related to the sum) the 4th cell shows an error as it thinks it's part of the formula.

My question is, is there a way to trick the formula in not looking at the 1st cell to stop the error coming up through out the sheet? I can add a separate column between cells 1 and 2 and hide it but dont want to have to do this as it looks messy.

Can anyone help?
6 Replies

Hello @Carlos2750,

 

Can you share your formula?

 

Thank you,

PReagan

@Carlos2750 

I'm just guessing,

you used the Autosum tool in the 4th cell which might have picked Cell 1 as well

If so, replace it with a SUM function and select Cells 3 & 3 by dragging

if it doesn't work

then I need to see the file

Thanks

Nabil Mourad

=SUM(B1:C1)
The number in cell A1 is separate and the sum is in cell D1. The error I get is the formula in this cell refers toba range that has additional numbers adjacent to it.
Solution

@Carlos2750 

Please uncheck this setting

image.png

 

Many thanks, something so simple.

You are welcome