Hi folks,

I'm trying to find the median of a column using two conditions.

I would like to calculate the median of column M, if column G cells
are less than 1995 but not when "0" (zero) has been entered in column
M ("0"). I've tried all sorts of combinations but none work so
far.

The following formula works well but doesn't take into consideration
the "0" condition:

{=MEDIAN(IF($G$4:$G$2001995, $M$4:$M$200))}

Any help would be appreciated,

Robert