+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    09-19-2019
    Location
    St. Louis
    MS-Off Ver
    16.29
    Posts
    3

    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).
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,781

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

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

  3. #3
    Registered User
    Join Date
    09-19-2019
    Location
    St. Louis
    MS-Off Ver
    16.29
    Posts
    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. #4
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,781

    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. #5
    Registered User
    Join Date
    09-19-2019
    Location
    St. Louis
    MS-Off Ver
    16.29
    Posts
    3

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need addtional criteria to count where "Actual" dates earlier that "Scheduled" DATE
    By Ochimus in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-22-2018, 07:54 PM
  2. Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  3. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  4. Performing "SUMIF" where "range" & criteria" are texts
    By joseedua in forum Excel General
    Replies: 1
    Last Post: 02-11-2010, 01:09 PM
  5. Replies: 0
    Last Post: 07-09-2009, 04:07 PM
  6. use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"
    By Luc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2005, 04:05 PM
  7. [SOLVED] "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du
    By TC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-11-2005, 10:06 PM

Tags for this Thread

Bookmarks

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