Formula using OR

Can someone help me I keep getting a error message, I know is has to be the OR function.

=COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", OR({Civic 2021 Range 4}, "(Stage 3) 3.2 - WON", {Civic 2021 Range 4}, "(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hey @Shannon Lacerda

Try this

=COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", {Civic 2021 Range 4}, OR(@cell="(Stage 3) 3.2 - WON", @cell="(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)

cheers,

Kelly

All comments

Kelly Moore

Hey @Shannon Lacerda

Try this

=COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", {Civic 2021 Range 4}, OR(@cell="(Stage 3) 3.2 - WON", @cell="(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)

cheers,

Kelly

Shannon Lacerda

Thank you so much that worked!!!!

Virtual HIGH FIVE!🖐️

Kelly Moore

🖐

Shannon Lacerda

How many logics can you use an in an OR function, I tried to add a 3 and it wont work

The bold is the new part.

=COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", {Civic 2021 Range 4}, OR(@cell = "(Stage 3) 3.2 - WON", @cell = "(Stage 3) 3.3 - LOST", @cell = "(Stage 3) 3.1 - RFP Submitted"), {Civic 2021 Range 1}, "Pursuit Plan Completed", {Civic 2021 Range 3}, MONTH(@cell) = 1)

Shannon Lacerda

Nevermind it worked, it was my error in not filling the cell !!!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.