Movie Genre Analysis

A. Movie Genre Analysis:For MEDIAN, MODE when i am using formula of excel= MEDIAN(IF(A2:A3870 = "Action",B2:B3870)) = MODE.MULT(A2:A3870 = "Action",B2:B3870)) I am getting value error it looks like no mode and median in there but i am still confused if i am doing any wrong steps let me know