I am trying to get the median of a column depending on a further 2 columns
and I have been trying the following:

=MEDIAN(IF('Incl 0 LOS ''09'!O4:O13427="SJH8",IF('Incl 0 LOS
''09'!P4:P13427="May",'Incl 0 LOS ''09'!E4:E13427)))

There are different numbers in column O, SJH1, SJH2 etc. Column P is a date
formatted as mmmm and Column E is random digits ranging from 0-49. All I get
is a return of 0 when I try and enter it. If I try and Ctrl,Shift & Return I
get NUM error. Please help.