https://bugs.documentfoundation.org/show_bug.cgi?id=171928
--- Comment #7 from CubicCigar <[email protected]> --- I would have to agree and that triggered a thought based on some further googling on the subject. If I replace references to my two non-contiguous named ranges (BPSysAll, BPDiaAll) and replace them with a tilde-separated and bracketed list of individual named ranges for each of my three test columns, I get these array formulas: Cell J4: {=AVERAGEIFS((BPSys1)~(BPSys2)~(BPSys3),BPTimes,">"&B3,BPTimes,"<="&B4)} Cell J16: {=MEDIAN(IF(BPTimes>$B3)*(BPTimes<=$B4), ((BPSys1)~(BPSys2)~(BPSys3)))} No errors, and the results look reasonable (have yet to confirm). It's an improvement, I think. -- You are receiving this mail because: You are the assignee for the bug.
