COUNTIFS do I need to use an OR aswell?

[vegaaltair]

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"})

 

[Weazel]

maybe with a slight modification...

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

 

[vegaaltair]

Ha I just knew it would be something simple thanks heaps!

 

[Weazel]

you're welcome, glad its working for you