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,"?*"))
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