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
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies