Is there a text value among number values?

[ljubo_gr]

Hello!
Please, how to check a array of cells to find is there a text value?
{=SUMPRODUCT(ISNUMBER(Sheet1!A1:D10)+ISNUMBER(Sheet2!A1:F20))>0}
This formula isn't working

 

[chicagocomputerclasses]

change ISNUMBER to ISTEXT

 

[Aladin Akyurek]

Hello!
Please, how to check a array of cells to find is there a text value?
{=SUMPRODUCT(ISNUMBER(Sheet1!A1:D10)+ISNUMBER(Sheet2!A1:F20))>0}
This formula isn't working

Faster like this:

=SUM(COUNTIFS(Sheet1!A1:D10,"?*"),COUNTIFS(Sheet2!A1:F20,"?*"))

 

[ljubo_gr]

Faster like this:

=SUM(COUNTIFS(Sheet1!A1:D10,"?*"),COUNTIFS(Sheet2!A1:F20,"?*"))

I'm speachless!! Thank you, both! THANK YOU, GOD BLESS!
WHERE is Thank you button?!

If you could..., since you're from Holland, if you have time: Changing the thousands separator in VBA - Page 3
Also here: http://www.mrexcel.com/forum/excel-questions/934331-problem-dot.html

 

[Aladin Akyurek]

I'm speachless!! Thank you, both! THANK YOU, GOD BLESS!
WHERE is Thank you button?!

You are welcome.

If you could..., since you're from Holland, if you have time: Changing the thousands separator in VBA - Page 3
Also here: http://www.mrexcel.com/forum/excel-questions/934331-problem-dot.html

I'm on an American system. Also, I hope someone into VBA is willing to take this up.