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 <rbjb62@gmail.com> 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+unsubscribe@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+unsubscribe@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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.