How do I sum the value of all used cells in a column when the length of column (i.e. the number of rows) varies.
Hello,
=SUM(A:A) if you want to sum values of all cells in column A (and the formula is in some other column)
=SUM(A2:A1048576) if you want the sum in cell A1
Note LibreOffice’s internal bookkeeping of used cells avoids performance issues using these “oversized” ranges.
Hope that helps.
If the answer helped to solve your problem, please click the check mark (
) next to the answer.
Thank you for your response.
geoffL