numbers2023
New Member
- Joined
- Jun 1, 2023
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
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.
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.