Median based on criteria

Hi there,

Im having a few issues trying to calculate the median in a document.

First up - Im trying to calculate the median on a set of parameters. I need for my median to be based by operations centre based on an audit score. For example the BIF median, the MIN median etc. This can be seen in the attached document in the tab GRAPHS. I have set up a basic formula but not sure what else i need to put in.

Secondly - Im having issues with the median formula when there is an N/A in the cell (as there is no input as yet). You can see in the main tabe AUDIT SCHEDULE AND DATA that i have set up column O to automatically assign a number based on column N. However if there is no score then an N/A is in cell O. This is fine - im just having problems when im trying to calculate the median.

Any help that can be provided will be GREATLY appreciated. I have attahced a sample document with some detail.

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down.

Are you looking for Median or Average?

I get Median of 3 for each of BIF, MIN, PAE, WAE

Make sure to confirm the formula with CTRL+SHIFT+ENTER and not just ENTER.

Try replacing MEDIAN with AVERAGE and confirm again.. maybe that was what you were expecting?

If not, please identify what you expect as results.

I used formula:

Please Login or Register  to view this content.

in B21, CSE confirmed and copied down