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
Bookmarks