TrainityTrainity
All ideas

Not able to perform median if

i am not able to use median if for the data, When i use this formula - =MEDIAN(IF(($C$2:$J$3656=P12) (K2:K3656<>""), $K$2:$K$3656)). I am getting a DIV/0 error even though there are no empty cells in the imdb score. I did that because each movie has multiple genres and i had to use text to columns to separate them. I even tried to use this formula =MEDIAN(IF(($W$2:$W$3656=""&P12&"") ($K$2:$K$3656<>""), $K$2:$K$3656)) while keeping the genres in single column, Nevertheless I am getting a error. Could you help me with this. I have attached the screenshot.