Forum Discussion

MathBarnes's avatar
MathBarnes
Copper Contributor
Nov 01, 2023

#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.

 

  • MathBarnes 

    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?

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        MathBarnes 

        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?

Resources