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 <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