Jordan uses a spreadsheet to keep track of how many hits each player on a baseball team has had in each game throughout the season. For every game, each player's name appears in a column that Jordan has titled "Player."
Next to that, a column titled "Hits" shows the number of hits for each player in a single game.
What function should Jordan use to find out how many times player C_Vaughn has had three or more hits in a
single game?
O COUNTIF(Hits,">2", Player,"C_Vaughn")
O COUNTIFS(Player, "C_Vaughn", Hits,">2")
O COUNTIF(Hits,">3", Player, "C_Vaughn")
COUNTIFS(Player, "C_Vaughn", Hits,">3")