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).
Bookmarks