AutoSum is a very quick and easy way of adding up a list of figures in LibreOffice Calc.

What it does…

Adds up a range of cells.

Syntax

=SUM(cellref:cellref)

Examples

=SUM(A1:A10)

=SUM(A1:F10)

Instructions To use AutoSum in LibreOffice Calc,

To use AutoSum in Calc,

  1. Click on the cell where you want the answer

    LibreOffice Calc AutoSum

  2. On the left-hand side of the formula bar, click on the AutoSum icon and choose Sum

    LibreOffice Calc AutoSum icon

  3. Check that all of the figures you want included in your total are in the range

    LibreOffice Calc AutoSum range

  4. If they are not, simply click and drag over the range of cells you want included

  5. Press Enter

    LibreOffice Calc AutoSum answer

  6. To copy the formula, click on the cell that contains it and move your mouse pointer into the bottom right-hand corner (your mouse pointer should look like a small black cross)

    LibreOffice Calc AutoFill

  7. Click and drag where you want the formula copied to

    LibreOffice Calc AutoFill

Shortcut

In Calc, click into the cell where you want your answer and press Alt + =

Cell Ranges that Contain Text

LibreOffice Calc Autosum containing text

Note – SUM ignores empty cells and cells containing text .

Video Using AutoSum in LibreOffice Calc

I hope you enjoyed finding out about AutoSum in LibreOffics Calc. To find out more about other useful functions in Calc, just click here to access the Resource page, or just click here to access the YouTube channel.