Forum Discussion
skbp1970
Apr 03, 2019Copper Contributor
Excel for my church financial reports
I have monthly, quarterly and annual reports. My quarterly reports are an accumulation of numbers for each category i.e. current, building fund, mission for January, February and March, I have been u...
SergeiBaklan
Apr 03, 2019Diamond Contributor
skbp1970 if your formula refers on individual cell(s) and if you move/delete the cell (not cell value), #REF appears. The workaround is to use ranges and/or offset. That was discussed here https://techcommunity.microsoft.com/t5/Excel/REF-Informular-when-Cut-Paste-the-reference-cells/m-p/391197#M28080