Medain if formula not working

Hi all,

I've a spreadsheet which has a medianif formula which use to work, and works occasionally but mostly only presents 0 value results and i'm not sure why.

Basically the formula is meant to report the median price if the number of bedrooms/bathrooms/car spaces match from the table. I've attached the spreadsheet for your reference.

As mentioned above, it works for some criterias but not all of them.

thanks,

Ernest

I'm not sure what you're referring to as the formula i see is referenced from the start to the end of the data set.