Forum Discussion
Median formula according to selected dates
What formula do I have to put into F2 (and F7, F12, F17 respectively) in order to find... - Median of the First Reply (excluding 'null' results) - The data F2 refers to is in accordance with ...
Hello, Sergei. I tried the formula you suggested, but this warning came up. What should I do?
This data is transferred over to Google Sheets as I need to display it there. Is that why there's a null error?
For Excel:
1) That is an array formula which shall be entered by Ctrl+Shift+Enter if only you are not on Excel with Dynamic Arrays
2) MEDIAN() ignores all texts in the range
Have no idea how it works in Google Sheets.