Share via

Why do I keep getting #REF! error for no reason?

Anonymous
2024-11-26T05:29:43+00:00

I don't know much about excel but I don't see anything wrong. I'm using a simple =sum(d2:g2) formula and errors when I try to copy the answers into a different cell. Wish I could attach a video.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-11-26T08:23:25+00:00

    Hi Matt Alavi,

    Thanks for visiting Microsoft Community.

    The link you provided in your reply points to a video that requires login and permissions, so we cannot clearly identify the issue you are encountering.

    However, if you want to copy the results obtained from a formula to other cells, you can choose Paste "Values" from the right-click menu when pasting, or directly use Ctrl+Shift+v to paste. This will only transfer the calculation results.

    If you need further assistance in identifying the issue, you can upload a picture in your reply.

    Looking forward to your update.

    Best Regards,

    Jonathan Z - MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2024-11-26T05:32:46+00:00

    Was this answer helpful?

    0 comments