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))))
You formula looks like an array formula ,but maybe it should look like this?
=MEDIAN(M7:M7382, IF(OR($C$7:$C$7382,">="&DATE(2013,1,1),$C$7:$C$7382,"<="&DATE(2013,12,31)),M7:M7382))
Confirm With Ctrl+Shift+Enter, not just Enter