Adding "OR" to a function

Hi there -

I have quite a complicated formula, and I'm having difficulties integrating an OR statement. The below formula works great, but I need it to find "David" OR "Chuck", where it currently is only finding David.

=SUM(COUNTIFS({MASTER TRACKING SHEET Range 3}, "CD", {MASTER TRACKING SHEET Range 2}, FIND("David", @cell) > 0, MASTER TRACKING SHEET Range 1}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023))) + (COUNTIFS({SE MASTER TRACKING S Range 2}, "CD", {SE MASTER TRACKING S Range 3}, FIND("David", @cell) > 0, {SE MASTER TRACKING S Range 1}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023)))

Thanks!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would incorporate it much the same way that you have used the AND function to combine the month and year criteria.

=SUM(COUNTIFS({MASTER TRACKING SHEET Range 3}, "CD", {MASTER TRACKING SHEET Range 2}, OR(FIND("David", @cell) > 0, FIND("Chuck", @cell)> 0), MASTER TRACKING SHEET Range 1}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023))) + (COUNTIFS({SE MASTER TRACKING S Range 2}, "CD", {SE MASTER TRACKING S Range 3}, OR(FIND("David", @cell) > 0, FIND("Chuck", @cell)> 0), {SE MASTER TRACKING S Range 1}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023)))

aecross

@Paul Newcome, that worked - thanks so much!

Paul Newcome

Happy to help. 👍️

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.