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

  • The formula is not dragged to the end of the data sheet and as per given criteria the Median will only be cacluated if three conditions mentioned matched to that of coloum ABC...

    Asha Kanta Sharma

    :):):)