Forum Discussion

Copper Contributor

Oct 16, 2019

Error with formula when moving cells #REF

I am doing a cash flow with several tabs and a collections / totals tab which has formulas totalling all the sheets together. If I move a cell I get a REF error in my formula. I have a similar spread...

excel

Formulas and Functions

office 365

PReagan

Bronze Contributor

Oct 16, 2019

Hello LHarris89,

If you would like to learn why you are getting the #REF! error or how to fix this issue, please refer to the following link:

https://support.office.com/en-us/article/how-to-correct-a-ref-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be