#Invalid Data Type Help

Stefano Ferretti

Hi All,

I have this simple functions:

=IF(COUNTIF(A1:D1,"apple"),"YES","NO")

The formula works fine if in the range A1:D1 I have 1 cell containing "apple".

If 2 or more cells contain "apple" the formula now returns "Invalid Data Type" error.

The same formula in excel works fine, so not sure what I'm doing wrong?

Thanks

Stefano Ferretti

OK, I think I got this one sorted as well ... guess typing the problem out helps me solve it

=IF(COUNTIF(A1:D1,"apple")>0,"YES","NO")

That is the solution

Andrée Starå

Hi Stefano,

Glad you got it working!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!