Forum Discussion
#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...
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?
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?
- Hello HansVogelaar
I deleted the top of the spreadsheet before uploading, but this information was not relevant to the collection of the data. I manually entered some numbers in some of the cells so that you could see that it wasn't calculating. No other worksheets are contained in the original workbook that has been deleted. My colleagues deleted some rows, but I thought that I corrected it when I replaced them and updated the formulas.
