SOLVED
Home

Excel cell error

Highlighted
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
Highlighted

Hello @Carlos2750,

 

Can you share your formula?

 

Thank you,

PReagan

Highlighted

@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.
Highlighted
Solution

@Carlos2750 

Please uncheck this setting

image.png

 

Highlighted
Many thanks, something so simple.
Highlighted

You are welcome

Related Conversations
IF statements and conditional formatting
clare1981 in Excel on
1 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Sumifs
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
0 Replies
everything is black and white in excel
Gold4trees in Excel on
1 Replies
Deleting unwanted rows and columns
chipg900 in Excel on
4 Replies