Home

Excel for my church financial reports

skbp1970
Occasional Visitor

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 using these reports for number of years. My Pastor set this up for me.  I have a column for income for my reports, but I'm getting the #ref in a cell each time I enter the formula. I used the online help and it said if you delete a cell or paste  over it this will cause the #ref. How do I clean up these cells so I can re-enter formulas and get the number results I'm looking for ?  

2 Replies
The error is alerting you that there is an inexistent reference in your formula. To evaluate whether all references in your function arguments are existing, select each function argument, press F9, then press Ctrl+Z.

@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/3...

Related Conversations
O365 Group Mailbox Reports?
Deleted in Office 365 Groups on
9 Replies
Exporting Meeting Call History to CSV/Excel
craig taylor in Microsoft Teams on
3 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies