Using COUNTIF with OR using multiple sources

KarenTF

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?

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.

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!!!