how to find errors or text that contain "#" in a data set

[numbers2023]

Hi All,
I have a data range where I want to find out if there is a cell in error by including the search term "#" in it, but I used COUNTIF and ISERROR but got a #SPILL error.
I landed on this formula set, but it's not returning correct results, meaning I manually entered a text value in the range, but it still shows that it's ok. Any ideas on how to correct this?

This is the formula I'm using: =IF(SUMPRODUCT(--ISNUMBER('EL Retrieve'!$B$11:$BR$152))>0,"Yes","No") but this works if it's a positive number, but if it's a negative number or text, it's not picking it up.

Here is my result:

Essentially, I just want to create a formula that will detect if any of the cells in the data range B11:BR152 have a # in it.

How can I do this? Thanks.

 

[Kerryx]

Is it IFERROR you should be using or am i off the mark?

Book3
	B	C	D
11	#NAME?		ERROR
12	#DIV/0!		ERROR
Sheet2

Cell Formulas
Range	Formula
D11:D12	D11	=IFERROR(B11:B12,"ERROR")
B11	B11	=SUM(a,b)
B12	B12	=125/0
Dynamic array formulas.

 

[numbers2023]

Thanks @Kerryx when I entered your formula above:
=IFERROR('Real Estate Retrieve'!B11:BR152,"error")

this is what I get in the results:

What else can I try?

 

[Fluff]

How about

=IF(COUNTIFS('Real Estate Retrieve'!B11:BR152,"*"),"Yes","No")

This will return yes if any of the cells contain text.

 

[numbers2023]

Great! Thanks @Fluff ! your solution worked!

 

[Fluff]

Glad we could help & thanks for the feedback.