#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

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.