I have the game scores from every nba game this season in a table. I am trying to figure out the MEDIAN for each NBA team. I know how to get each teams Away Median Score and Home Median Score by using =MEDIAN(IF(nba_2122_schedule[Away Team]=SDs!A3,IF(ISNUMBER(nba_2122_schedule[Away Score]),nba_2122_schedule[Away Score]))). However, what I cannot figure out is to how to get an OVERALL MEDIAN . any help would be appreciated.