Excel: # value error in Median formual


I am getting #value error when I try below formula. Can someone please advise =MEDIAN(M7:M7382, IF($C$7:$C$7382,">="&DATE(2013,1,1),OR($C$7:$C$7382,"<="&DATE(2013,12,31))))


This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of September 14, 2014.


For more resources for Microsoft Excel