#REF error when cells definitely exist

[Shaz11]

I am receiving this error when I know that the cells that are referenced definitely exist. Could there be too many formulae in my spreadsheet?

 

[Shaz11]

Another formula to try that might pinpoint the potential error(s)

=LET(d,'Daily Data 3min Reach'!JP9:KT9,TEXTJOIN(", ",,FILTER(ADDRESS(9,COLUMN(d),4),ISERROR(d),"No errors")))

Fantastic - thank you Rory! You are all amazing and I am an idiot! I had a one cell error that I had missed

 

[Shaz11]

If that is the one returning a #REF! error, then the first thing would be to carefully check JP9:KT9 in 'Daily Data 3min Reach' to ensure one of those cells does not contain a #REF! error.

If that is not the problem I don't think XL2BB will help in this case as it looks like you have too much data to use XL2BB.

Instead, if still a problem, can you upload a copy of the file, with any sensitive data disguised or removed (provided the error still exists) to somewhere like DropBox or OneDrive or Google Drive etc and provide a link here so we can take a look at the actual file?

Thank you very much - that was the issue but I missed it initially

 

[Shaz11]

If you enter:

=COUNT('Daily Data 3min Reach'!JP9:KT9)

into a cell, what does it return?

Thank you for your advice - You have all been so helpful

 

[Shaz11]

In that reference into other sheet? Maybe tiny mistype in sheet name?

Thank you for your advice

 

[Peter_SSs]

You are welcome. Glad we could assist to resolve the issue. Thanks for the follow-up.