I am trying to find the STDEV of a specific teams score based on the seasons completed games.
I want to accomplish this by using vlookup. I came up with this formula but it shoots a DIV/0 error.
=STDEV(vlookup(B19,'2021 Game Log'!A2:B,2,false))
basically now I have the STDEV of ALL AWAY GAMES.... I'd like to refine that and get the STDEV of ONLY the AWAY team that's listed in that games "B cell". The scores are listed in 2021 Game Log. (that make sense?)
Here is a screenshot that might help.