Using COUNTIF with OR using multiple sources

I have two sheets with similar information taken in from different locations on both forms. I want to create a formula to Count if an entry is made by a location from EITHER form, which will uncheck a box if either sheet has the submission from a location. I was able to first input the first sheet into the formula:

=IF(COUNTIFS({Sheet 1 - Location Range}, @cell = [Location Column]@row) = 0, 1)

And this worked! But then I wanted to be able to add in the OR part to include the other sheet as well:

=IF(COUNTIFS({Sheet 1 - Location Range}, @cell = [Location Column]@row, OR({Sheet 2 - Location Range}, @cell = [Location Column]@row) = 0, 1)

But I keep getting an error. Any ideas?

Find more posts tagged with

Accepted answers

prime_nathaniel

@KarenTF is there a reason you cant just do the sum of both counts > 0? count would = 1 or 2 both are > 0 and would indicate that the box should not be checked.

All comments

prime_nathaniel

@KarenTF is there a reason you cant just do the sum of both counts > 0? count would = 1 or 2 both are > 0 and would indicate that the box should not be checked.

KarenTF

Unfortunately, no, I thought this would work as well, but it wants to only count the entries if BOTH conditions are met, rather than either/or.

KarenTF

Actually, yes! I see what you meant. Thank you!!!

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.