https://bugs.documentfoundation.org/show_bug.cgi?id=171928
--- Comment #4 from CubicCigar <[email protected]> --- Inspired by the first comment on this bug, I decided to make all my named ranges just that, named ranges, on the off chance named and database range types led to this error message. Apparently not, as the same "Err:502" appears, leaving the difference between how conditions are entered with the AVERAGEIFS() function and the way they're entered when combining the MEDIAN() and IF() functions. In the case of AVERAGEIFS() conditional operators are double-quoted and concatenated with the value being compared. With the IF() function, conditions are entered without the need for quoting. Perhaps this is significant, I don't know enough Calc syntax to judge. -- You are receiving this mail because: You are the assignee for the bug.
