Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Tue, 07 May 2024 08:15:34 +0000

How to Post a Message for Support

Post From: MEDIAN() of range in SC non-CLR spreadsheet

[2014-05-22 13:29:54]
[Go To First Post]
joshtrader - Posts: 439
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?