Results 1 to 12 of 12

Countif with multiple AND/OR criteria

Threaded View

  1. #9
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Countif with multiple AND/OR criteria

    @daddylonglegs
    Your formula is equivalent to:
    =SUM(COUNTIFS(Accounts!B:B,A4,Accounts!F:F,{"Medcare Company","Inv Lab","Physicians"}))
    isn't it? I believe it just disregards the Extended Hours criteria.

    EDIT: Ah, I see it now. Never mind.
    Last edited by Cutter; 05-16-2012 at 05:45 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