Hi everyone! I have exactly the same problem as mentioned here: http://www.mrexcel.com/forum/excel-questions/143813-sum-values-column-until-next-empty-cell.html Only that solution doesn’t work for libreoffice - I just do not know how to make it work. Or is there another formula? No pivot table or makros please. Thanx a lot in advance.
This seems to work
=SUM(OFFSET(A2,0,0,MATCH(1,IF(A2:A100="",1,0),0),1))Just want to note (as in the linked article) that this formula needs to be entered as an array (CTRL+SHIFT+ENTER).
Thank you Dave for such a prompt answer. Seems like I have to learn more basics of liboffice because this I can’t get to work either. Maybe it is some setting issue? First it returned error #501 and after changing “,” to “;” #VALUE! error…
@koliplay, it should work but the given form will only do so in cell A1 with the list of values to sum beneath in cells A2 to A100 (broken at some point by a blank cell). It sounds like you are using semi-colon as a delimiter (which is more international) so the form =SUM(OFFSET(A2;0;0;MATCH(1;IF(A2:A100="";1;0);0);1)) is required.
Thanx to both of you - I’ve been entering it in A2 so as soon as I get back to calc I’m gonna give it another try. but I am sure it is solved.