Results 1 to 7 of 7

Countifs with more than 2 or statements

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    NY,NY
    MS-Off Ver
    MS Office 2010
    Posts
    13

    Countifs with more than 2 or statements

    Hi all,

    The following formula works as intended:
    SUM(COUNTIFS(Data!$O:$O,">="&Leaderboard!I$202,Data!$O:$O,"<"&Leaderboard!J$202,Data!$DH:$DH,Leaderboard!$B203,Data!$HG:$HG,{"<>-","-","<>-"},Data!$HD:$HD,{"Q4 2018 Campaign","Q4 2018 Campaign",""}))
    However, I read that having more than two or statements inside the countifs() statement, will cause the wrong results, ie. I shouldn't do this:
    SUM(COUNTIFS(Data!$O:$O,">="&Leaderboard!I$202,Data!$O:$O,"<"&Leaderboard!J$202,Data!$DH:$DH,Leaderboard!$B203,Data!$HG:$HG,{"<>-","-","<>-"},Data!$HD:$HD,{"Q4 2018 Campaign","Q4 2018 Campaign",""},Data!$HE:$HE,{">Data!$HF:$HF";""}))
    How can I write such countifs() formula with 3+ or statements?
    Last edited by edost4; 10-12-2018 at 10:45 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct to replace countifs as countifs don't work on external source reference
    By KrishnaSagar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-02-2017, 02:33 AM
  2. How can I run CountIfs + CountIfs without double counting?
    By hiitsjessie in forum Excel General
    Replies: 1
    Last Post: 02-06-2017, 04:49 PM
  3. [SOLVED] Excel 2007: Combining countifs statements
    By 2ruble in forum Excel General
    Replies: 4
    Last Post: 03-25-2014, 06:35 PM
  4. [SOLVED] Can I nest Countifs Statements in an IF / OR statement?
    By CWatsonJr in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-02-2013, 04:13 PM
  5. COUNTIFS OR...multiple countifs without duplication in the numbers
    By HooligaD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2012, 09:53 AM
  6. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  7. Replies: 12
    Last Post: 05-15-2009, 08:38 AM

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