Forum Discussion
#REF!
I am working on a expense report. Each month has its own sheet and the summary sheet which shows how much money in each category was spent in each month. For the month on March is is showing #REF! for each category for the summary. Also for my yearly total it is showing the same error. Not sure how to fix this.
Hi Emily,
For so general description that could be only quite general answer, it's in this support article https://support.office.com/en-us/article/How-to-correct-a-REF-error-822c8e46-e610-4d02-bf29-ec4b8c5ff4be?ui=en-US&rs=en-US&ad=US
Summary for the year gives an error since you have it for March. Most probably if you correct March formula annual summary also will be correct.
