Not sure if you've gotten the answer you're looking for. Others have mentioned enabling/disabling the automatic updating of formulas. If that's what you needed this isn't the answer you're looking for.
Chapter 1 pg 20 of the 7.2 Calc Guide identifies the sum function as part of the formula bar and describes how it is used. If you are looking for a function that will sum a column (or row or table) of figures when clicking in the worksheet then what you're looking for is the sum function. That is part of a button just to the left of the input line. The button has the sigma symbol and a down arrow on it, Σ▾. In the worksheet... Select an empty cell at the bottom of the column of figures to sum. Next click the Σ▾ button, it will display a list of functions including SUM. Click on SUM and the sum formula is entered into the cell with the range automatically selected from the column above. Press Enter and the selection is summed. Or BEFORE the button is clicked Select the range of cells to be summed and one empty cell beyond Next, click the Σ▾ button to reveal the list of functions, including SUM. Click on SUM and the sum formula is entered into the cell with the range included Press Enter and the selection is summed. On Wed, Nov 1, 2023 at 10:08 AM Jackie Beauchamp <[email protected]> wrote: > Good morning > I am unsure where the total (auto sum) feature is in order to total my > columns, can you please > advise where that tool/feature is in CalcGuide ? > Sincerely yours, > Jackie Beauchamp > > -- > To unsubscribe e-mail to: [email protected] > 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 > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011 -- To unsubscribe e-mail to: [email protected] 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
