# 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).  Register To Reply

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

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

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!  Register To Reply

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  Register To Reply

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  Register To Reply

#### Thread Information

##### Users Browsing this Thread

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

#### Tags for this Thread #### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1