Excel cell error

[Carlos2750]

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?

[#2]

Hello @Carlos2750,

Can you share your formula?

Thank you,

PReagan

[#3]

@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

[#4]

=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.

[#5 · Accepted solution]

@Carlos2750 

Please uncheck this setting

[#6]

Many thanks, something so simple.

[#7]

You are welcome