COUNTIFS do I need to use an OR aswell?

vegaaltair

New Member
Joined
Sep 12, 2014
Messages
7
Hi

I am attempting to count how many bets have placed 1st, 2nd or 3rd by a certain method but I cannot figure out if I will be required to use an OR function for the 1st, 2nd 3rd part?

Formula
=COUNTIFS(Bets!$J$10:$J$10000,X6,Bets!$K$10:$K$10000,{"1st","2nd","3rd"})
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Weazel

Well-known Member
Joined
Dec 24, 2011
Messages
3,155
maybe with a slight modification...

=SUM(COUNTIFS(Bets!$J$10:$J$10000,X6,Bets!$K$10:$K$10000,{"1st","2nd","3rd"}))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,447
Messages
5,528,803
Members
409,837
Latest member
karnasrinivas
Top