# Count if (Criteria Range = "X") AND (Criteria Range="X" OR Criteria Range="X")

1. ## Count if (Criteria Range = "X") AND (Criteria Range="X" OR Criteria Range="X")

I need help figuring out a formula to Count if (Criteria Range = "X") AND (Criteria Range="X" OR Criteria Range="X").

The formula I have tried using unsuccessfully was: =COUNTIF(\$O\$2:\$O\$601,"X")+COUNTIF(\$Q\$2:\$Q\$601,"X",\$R\$2:\$R\$601,"X")

The background: I need a count of companies that fall in a baseline period annotated by "X" (Criteria range 1) and if they have a 2016 survey on file annotated by "X" (Criteria Range 2) OR a 2017 survey on file annotated by "X" (Criteria Range 3).

2. ## Re: Count if (Criteria Range = "X") AND (Criteria Range="X" OR Criteria Range="X")

F2=countifs(a2:b700,"x",c2:d700,"x")

3. ## Re: Count if (Criteria Range = "X") AND (Criteria Range="X" OR Criteria Range="X")

I tried =COUNTIFS(A2:A700,"x",B2:C700,"x")for my exact ranges and it returned #VALUE!

4. ## Re: Count if (Criteria Range = "X") AND (Criteria Range="X" OR Criteria Range="X")

again

F2=countifs(a2:b700,"x",c2:d700,"x") try is 30

5. ## Re: Count if (Criteria Range = "X") AND (Criteria Range="X" OR Criteria Range="X")

I moved things around on my master/original spreadsheet to better fit this formula and yielded the accurate results. Thank you for you help! :D

There are currently 1 users browsing this thread. (0 members and 1 guests)