https://bugs.documentfoundation.org/show_bug.cgi?id=145640
--- Comment #7 from Colin <[email protected]> --- (In reply to Colin from comment #6) > (In reply to Colin from comment #5) > > (In reply to Eike Rathke from comment #4) > I have failed to properly identify that if the summation range is a column > then the references work correctly (3700+ cells and counting) but if they > are a row then it goes awry. =IF(K414="";"";ROUND(SUM(J413;J412;J411;J410;J409;J408;J407);1)) This correctly summs clusters of eight events regardless of whether they are sorted in ascending or descending order. -- You are receiving this mail because: You are the assignee for the bug.
