="&DATE(2013,1,1),OR($C$7:$C$7382,"<="&DATE(2013,12,31)))) .">
Most valuable professional
  • Hot Topics

Excel #Value error in Median formula

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel