so I have a bit of an issue with the =sum function....
so right now I have some lines summed up, it looks like this: =SUM(E48:E51,K2:K11) when I go to add another cell to it, it should look like this: =SUM(E48:E51,K2:K12) but when I hit enter, instead of the cell displaying the result, it literally shows "=SUM(E48:E51,K2:K12)" (without quotation marks)
I've had no issues on the hundreds of other times I've done this same scenario on dozens of documents....I've tried closing the document and reopening it but still same results, there are no formatting issues either.....I'm truly at a loss as to what is going on...
@NevaMO Make sure that you haven't accidentally pressed the "Show Formulas" button on the Formulas Ribbon. Press it once and see if it resolves the issue.
Alternatively, the cell where you entered the formula could have been formatted as Text before you entered it. Changing it back to General or Number only will not help. You would need to select the formula in the formula bar and re-confirm it, i.e. press Enter.