On 3/6/19 10:18 AM, Luuk wrote: > > On 6-3-2019 17:48, Tom Williams wrote: >> On 3/6/19 8:26 AM, Tom Williams wrote: >>> I know it's odd to ask for Excel help in this mailing list but I need >>> help locating a LibreOffice Calc function/feature in Excel. :) >>> >>> I'm helping a friend create a billing invoice and since I'm a Linux >>> user, I'm using Calc to build the template. So far, it's working well >>> and given I'm not an Excel user, I find myself struggling some in >>> getting Excel to "behave". Anyway, I recently discovered the "/Expand >>> reference when new rows are inserted/" in Calc. It does exactly what I >>> needed. When I add/remove a row in/from the spreadsheet, my total >>> "SUM()" formula is updated automagically. >>> >>> Does the equivalent feature exist in Excel? What I've found is, when >>> adding rows *after* the last row in my SUM() formula, the new row is >>> excluded from the SUM() formula. So, my formula is "=SUM(D7:D27)". >>> Once I add row 28, I need the SUM() formula to be updated to >>> "=SUM(D7:D28)". Conversely, when row 28 is removed, I want the SUM() >>> formula to be updated to "=SUM(D7:D27". In Calc, the "/Expand >>> reference when new rows are inserted/" feature does this work for me. >>> >>> I did some web searching and found this article: >>> >>> https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html >>> >>> >>> but I hope to find an easier and more flexible way to accomplish what I >>> need. Or is that approach what I really should use? >>> >>> Thanks in advance! >>> >>> Peace... >>> >>> "The Other" Tom >>> >>> >> Nevermind! I found this: >> >> https://bettersolutions.com/excel/formulas/automatic-expansion.htm >> >> That should do what I need! >> >> Thanks anyway! :) >> >> Peace... >> >> "The Other" Tom >> > When i was reading above, i thought you were search for subtotals. > > Excel has also a function named SUBTOTAL() > > https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939 > > > > > Thanks for the info! Sorry I wasn't more clear. :( I just needed the SUM formulas to update as I added/deleted rows. :)
Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
