Thank you for your advise. Yes, I'll guess I'll have to do that, redefine the ranges to (a little more then) the needed range, then it should probably work. I just wish I had tested this sooner. And the reason why I wanted to do this is simple; when you have a sheet like this: the easiest way to insert new data 'C' inbetween column B and D is inserting a new column rather then cut-pasting everything to the right - and usually the savest way, but not this time. And I'd named the entire rows because when you have more then one screen of data, it is the easiest way to just click the row header (A) and define the name in the Name-box on the left top. None of the tutorials I used warned against the problem that when inserting, it would drop the (unused) excells allright, but not move the formula along. ABDEF ABDEF ABDEF ABDEF ABDEF -- View this message in context: http://nabble.documentfoundation.org/Sum-of-sub-section-Calc-named-row-column-error-bug-feature-or-wrongfull-implementation-tp4103196p4103447.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted