COUNTIF counting non existent item

[HSEQ]

I have a UDF I use in a number of workbooks that returns either "", "File exists." or "File doesn't exist." entered into cells R19:R94 and then have the formula =COUNTIF(R19:R94,"File doesn't exist."). Everything works fine in most workbooks except for one workbook where the COUNTTIF returns 1 more than the number of occurrences of "File doesn't exist.". When the count should be zero, but is 1, I have tried searching for the string, using conditional formatting but the string is not found. COUNTIFS also returns one more.

I have run out of ideas, any thoughts appreciated.

 

[JoeMo]

Perhaps in that workbook you have a hidden row between row 18 and row 95 that contains "File doesn't exist."
If that's not the case, can you post the UDF, and a sample of the data that produces the unexpected result of 1 using XL2BB?
XL2BB - Excel Range to BBCode

 

[HSEQ]

Found a hidden row I didnt realise existed, rooky error. Many thanks for the assistance!

 

[JoeMo]

Found a hidden row I didnt realise existed, rooky error. Many thanks for the assistance!

You are welcome - thanks for the reply.