Won't calculate Median Value

I have a conditional median value formula that works on every other column except one. The formatting is the same between the two, there are values for it to calculate, but it returns a zero. The formula is good, am I missing something with the data it's going through?

Here's the formula, but like I mentioned, it's working perfectly with similar data in the same workbook.

{=MEDIAN(IF((('2007'!$D$2:$D$500=F44)),'2007'!$BM$2:$BM$500))}

Any ideas?

Perhaps the values in column BM are formatted as text - what do you get with this formula?

=ISNUMBER('2007'!BM2)

You could convert to numeric with text to columns - select column BM - Data > Text to columns > Finish

or adjust the formula, try

=MEDIAN(IF('2007'!$D$2:$D$500=F44,'2007'!$BM$2:$BM$500+0))

confirmed with CTRL+SHIFT+ENTER

Try this ARRAY FORMULA...

Please Login or Register  to view this content.

Does that help?

Did you try Ron's suggestion - it works for me

Your original formula was counting blank cells in column G as zeros....and because there are many of those the median is also zero. Ron's version takes those zeroes out

I attached an edited version of your posted file.
In that file I posted the exact ARRAY FORMULA that I posted above:
C2: =MEDIAN(IF(($F$7:$F$505=B2)*($G$7:$G$505<>""),$G$7:$G$505))

I copied C2 and pasted it into C3:C5.

All formulas calculated the correct median.

Am I missing something?