[libreoffice-users] CalcGuide auto sum
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: 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
Re: [libreoffice-users] CalcGuide auto sum
On Wed, 1 Nov 2023 at 09:08, Jackie Beauchamp wrote: > 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 ? The default in most spreadsheets, including Calc, is to automatically update with every change to the spreadsheet. You may have inadvertently turned it off. From the menu, check DATA » Calculate » AutoCalculate and ensure there is a checkmark there. -- T. R. Valentine A rich heart may be under a poor coat. -- 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
Re: [libreoffice-users] CalcGuide auto sum
I could find it but the help says it is somewhere. I have always put a sum formula on the last row I wanted to total. It would be easier if we find the button. :-) On 2023-11-01 09:46, Jackie Beauchamp 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: 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
Re: [libreoffice-users] CalcGuide auto sum
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 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: 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 > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011 -- 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