Forum Discussion

Carlos2750's avatar
Carlos2750
Copper Contributor
Jun 25, 2019

Excel cell error

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 (no...
Excel
Formulas and Functions
PReagan's avatar
PReagan
Bronze Contributor
Jun 25, 2019

Hello Carlos2750,

 

Can you share your formula?

 

Thank you,

PReagan

  • Carlos2750's avatar
    Carlos2750
    Copper Contributor
    Jun 25, 2019
    =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.
    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Jun 25, 2019

      Carlos2750 

      Please uncheck this setting

       

      • Carlos2750's avatar
        Carlos2750
        Copper Contributor
        Jun 25, 2019
        Many thanks, something so simple.

Resources