https://bugs.documentfoundation.org/show_bug.cgi?id=151863
--- Comment #4 from Eike Rathke <[email protected]> --- (In reply to m.a.riosv from comment #3) > Result with excel is #!REF! (Spanish) Thus I tend to close this as a wontfix. > Like @eike has pointed, the issue is with the comparator. Not really. The newly attached file is a different problem as it does not involve INDIRECT() and thus no reference list is created, though slightly related. The array formula {=SUM($Week1.B$1:$Week5.B$8=A2)} for the comparison (as for any operator/function that expects scalar values as operands) would have to create a 3D array of $Week1.B$1:$Week5.B$8 that simply is nowhere supported. {=ABS($Week1.B$1:$Week5.B$8)} equally does not work. -- You are receiving this mail because: You are the assignee for the bug.
