Forum Discussion
Formula reference
Hello, I am collecting some stats about football results on a sheet and then pulling info from that sheet to create make sheets for each individual player. Unfortunately, the formulae that I am...
You can use
=COUNTIF(INDEX(Results!$1:$1000, MATCH($B$1, Results!$A$1:$A$1000, 0), 0), "Red")
You can use
=COUNTIF(INDEX(Results!$1:$1000, MATCH($B$1, Results!$A$1:$A$1000, 0), 0), "Red")
Thank you!