Forum Discussion
Solved
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...
=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.
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.