Mode of IMDB scores: #VALUE! While calulating mode facing issue need help on this =ModeIf(IF('IMDBMovies (1)'!G:G=Sheet1!D3,'IMDBMovies (1)'!U:U),0)