Results 1 to 12 of 12

Countif with multiple AND/OR criteria

Threaded View

kazphilips Countif with multiple AND/OR... 05-16-2012, 04:26 PM
Cutter Re: Countif with multiple... 05-16-2012, 04:42 PM
kazphilips Re: Countif with multiple... 05-16-2012, 04:43 PM
Cutter Re: Countif with multiple... 05-16-2012, 04:48 PM
smls Re: Countif with multiple... 05-16-2012, 04:53 PM
kazphilips Re: Countif with multiple... 05-16-2012, 05:01 PM
daddylonglegs Re: Countif with multiple... 05-16-2012, 05:34 PM
Cutter Re: Countif with multiple... 05-16-2012, 05:34 PM
Cutter Re: Countif with multiple... 05-16-2012, 05:41 PM
kazphilips Re: Countif with multiple... 05-17-2012, 09:03 AM
daddylonglegs Re: Countif with multiple... 05-17-2012, 10:59 AM
kazphilips Re: Countif with multiple... 05-17-2012, 12:28 PM
  1. #1
    Registered User
    Join Date
    11-18-2011
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2016
    Posts
    31

    Countif with multiple AND/OR criteria

    I'm trying to count how many accounts of a given type appear for a given sales rep. If you see my attachment, B4 needs to show the total number of only the Medcare Company, Inv Lab and Physicians accounts with Extended hours are listed for Andrew Williams on Sheet 2 "Accounts". The formula below doesn't work and I'm not sure why:
    =COUNTIF(Accounts!$B:$B,A4)*AND(OR(Accounts!$F:$F="Medcare Company",Accounts!$F:$F="Inv Lab",Accounts!$F:$F="Physicians",Accounts!$H:$H="Yes"))

    REP ID countif test.xlsx
    Last edited by kazphilips; 05-17-2012 at 12:34 PM.

Thread Information

Users Browsing this Thread

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

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