Forum Discussion
Solved
Value Error when copying formula
Hi Folks. Apologies from the outset: I'm not great with Excel. I'm using an simple Excel spreadsheet that I set up a long time ago. I have a "Totals" column where the final cell contains a form...
- There is nothing wrong with your formula.
The problem is with the values. Maybe some text value but showing as numbers, or different codification.
Try to copy the values and paste them as values (Paste Special > Values) in a new workbook.
Them apply the SUM() formula.
There is nothing wrong with your formula.
The problem is with the values. Maybe some text value but showing as numbers, or different codification.
Try to copy the values and paste them as values (Paste Special > Values) in a new workbook.
Them apply the SUM() formula.
The problem is with the values. Maybe some text value but showing as numbers, or different codification.
Try to copy the values and paste them as values (Paste Special > Values) in a new workbook.
Them apply the SUM() formula.
- Thank you Juliano.
Your reply prompted me to copy the whole workbook into a new one and it's working perfectly! Thank you so much. Best regards. Roger- You are welcome.
If it worked please hit the like button and mark it as solved.
