Results 1 to 7 of 7

CountIFS using an OR function

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2010
    Location
    Midlands
    MS-Off Ver
    Excel 2010
    Posts
    38

    CountIFS using an OR function

    Hi,

    I have tried searching the forums and google for an answer to do this but I cannot seem to find a solution to my problem.

    I am using Excel 2007 and looking at a large amount of data. To simplify the problem I have built the Table below
    A B
    1 Jack
    1 James
    2 John
    2 jack
    2 james
    1 james

    I want to use Countifs to display the amount of times that Jack OR James are displayed in B AND 1 is displayed in Column 1.

    I have tried to do this through, = countifs($A:$A, "=1", $B:$B, {"Jack", "James"})
    however the result it returns only reviews the first in the array, in this case, Jack.

    Is there any way to use a nested OR function within a Countifs function without having to create a separate column and using =if(OR(A1="Jack", A1="James"),1,0) and then using Countifs with =countifs($A:$A, "=1", $C:$C,1) as the data set I am using is very large and this would be very time consuming.

    Any / all help would be appreciated!

    Many thanks

    Maudise
    Last edited by Maudise; 08-09-2010 at 11:03 AM.

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