[Bug 171928] EDITING: non-contiguous named range from Sheet X throws Err:502 in Sheet Y for MEDIAN function, but not AVERAGEIFS function

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=171928

--- Comment #9 from CubicCigar <thirdmoonima...@gmail.com> ---
Still struggling with this, but have made progress with the AVERAGEIFS function
results, i.e., they are now correct when I use this form of an array function
argument in J4:

{=AVERAGEIFS(BPSys1~BPSys2~BPSys3,BPTimes,">"&B3,BPTimes,"<="&B4)}

It correctly combines the non-contiguous ranges into one and calculates the
middle value, as expected.

With MEDIAN, unfortunately, I get the correct results when I simply provide the
non-contiguous ranges as a reference list:

=MEDIAN(BPSys1~BPSys2~BPSys3)

but once I apply filter conditions on that reference list with a nested IF(),
and save it as an array function, Err:502 is thrown:

{=MEDIAN(IF((BPTimes>$B15)*(BPTimes<=$B16),BPSys1~BPSys2~BPSys3))}

Interestingly, if I substitute a numeric value, like 2.2, for the reference
list, I get 2.2 as a result, suggesting the filter conditions are being
correctly evaluated by the function.

Really hoping someone can confirm this as a bug or not.  Thanks.

-- 
You are receiving this mail because:
You are the assignee for the bug.