In Microsoft Excel, users will sometimes experience errors in Excel formulas. Errors usually occur when a reference becomes invalid (when there is an incorrect reference in your functions, or ...

To fix this issue, you should use the colon to separate the first cell from the last cell, for example, =SUM (A2:A3). The colon is used to separate when you refer to a continuous range of cells in ...