What is wrong with my formula?

Probably something obvious...

=COUNTIF((Position2:Position136, (CONTAINS("Medical Assistant", @cell))), AND([Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell))))

Find more posts tagged with

Accepted answers

L_123

Original Formula:

=COUNTIF((Position2:Position136, (CONTAINS("Medical Assistant", @cell))), AND([Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell))))

You went a little crazy on the parenthesis is the first thing I spot

=COUNTIF(Position2:Position136, CONTAINS("Medical Assistant", @cell), AND([Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell

You don't need the and statement. You need a countifs to put multiple criteria into this.

=countifs(position2:position136,contains("Medical Assistant",@cell),[cleared to return?]2:[cleared to return?]136,or(contains("No",@cell),contains("Contingent",@cell

and that should work I think

All comments

L_123

Original Formula:

=COUNTIF((Position2:Position136, (CONTAINS("Medical Assistant", @cell))), AND([Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell))))

You went a little crazy on the parenthesis is the first thing I spot

=COUNTIF(Position2:Position136, CONTAINS("Medical Assistant", @cell), AND([Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell

You don't need the and statement. You need a countifs to put multiple criteria into this.

=countifs(position2:position136,contains("Medical Assistant",@cell),[cleared to return?]2:[cleared to return?]136,or(contains("No",@cell),contains("Contingent",@cell

and that should work I think

Grace Tidwell

Awesome that worked, thank you!

Mike Wilday

It looks like you might be trying to do more than one criteria in COUNTIF. Have you tried constructing this as a COUNTIFS?

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.