Struggling with MEDIANIF, get #NUM!

[somanyqs]

On Excel for Mac 2011

I have a median if array (am using C-S-E) that works for about 5 of my criteria, but when I add in my last criteria, it goes to #NUM!.
I know I am missing something basic, and that #NUM! is a clue for where I am going wrong, but can't figure it out...

So I have for example:
{=MEDIAN(IF(CAR_HP=B1,IF(COLOR_="Yes",IF(DENTED="No",IF(OPTIONS="Standard",VALUE)))))}

Where each of the names above refers to a column in another sheet that holds all the data, and B1 is the horsepower

When I try adding the FY (fiscal year) of purchase (which I type in cell A1) to the formula, it produces #NUM!

I've tried a few things with no luck (including formatting the cell A1 as a number and text, and same with the values in FY on other sheet)
{=MEDIAN(IF(CAR_HP=B1,IF(COLOR_="Yes",IF(DENTED="No",IF(OPTIONS="Standard",IF(FY=A1,VALUE))))))}

{=MEDIAN(IF(CAR_HP=B1,IF(COLOR_="Yes",IF(DENTED="No",IF(OPTIONS="Standard",IF(FY="2013",VALUE))))))}
tried testing 2013 directly in formula, no luck

Thanks for any tips!

 

[somanyqs]

I should add, when I do an AVERAGEIFS, I can get the formula to work fine...which makes me thinking I'm missing something even more basic! :-O