Hello, If your list is in a column, you can use the ROW() function to figure out on which line you are. For example, if the first entry is in cell B2:
Formula in cell B2: =sum(D2/(90-row()+row($b$2)) If you now drag this to cell B3, the formula will be converted to =sum(D3/(90-row()+row($b$2)) ROW() without arguments gives you the row number of the cell, while placing a cell reference gives you the row of that cell. You will notice that I used "$b$2": doing this tells Calc that if you drag or copy the cell containing the formula, the reference cannot be changed. By the way, I am not sure I understand your usage of SUM() in the formula you provided. Unless I am missing something, D17/76 and sum(D17/76) should yield the same answer. I hope this helps. Best regards, Rémy. Le mercredi 09 octobre 2024 à 05:49 +0100, Sharon Kimble a écrit : > > I'm trying to construct a spreadsheet which will track my writing > goals for a 90-day period and is of this format '=SUM(D17/76)' and > the cell beneath it is '=SUM(D18/75)'. > > So how can I get it such that the first figure is increasing, and the > second figure is decreasing, and I can just drag the cells downwards > and it auto-populates the cells as I'm trying to get them, please? Or > in other words, at the > end of the 90-day period the second figure will be zero, please? > > Thanks > Sharon. -- 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
