Support Board
Date/Time: Tue, 26 Nov 2024 17:25:05 +0000
Post From: MEDIAN() of range in SC non-CLR spreadsheet
| [2014-05-22 13:29:54] |
| joshtrader - Posts: 488 |
|
In the old SC spreadsheet, I can do: =MEDIAN($A:$A5000) In the new SC spreadsheet, I get a "Value!" error if there are blank cells in the range. How should I get the value of all cells which are in a range, even if it contains empty cells? |