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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies