Forum Discussion
MathBarnes
Nov 01, 2023Copper Contributor
#REF! Error
Hello,
I have an Excel spreadsheet that I am using to collect data. I am using formulas and in certain cells the formulas are working but in others they are not- #REF!. I have clicked on the icon to get further information and help resolving the error, but nothing has helped. Please help me with a solution to remove the #REF! errors from the spreadsheet. Thanks in advance!
Some working, but man are not.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- MathBarnesCopper Contributor
I have uploaded a document. As you complete the cells moving to the right of the spreadsheet, the spreadsheet begins to not automatically use the inserted formula to calculate the numbers.
Let's take a look at column H (# of Students Passing 68-79%).
Cells H4 to H11 contain values that look like they have been entered manually.
But the cells from H12 down contain a COUNTIFS formula that refer to a range that cannot be found. Did this workbook originally contain more worksheets that have now been deleted?