What is the intended method to copy a formula to create a column of running totals?
Post by FJCC » Mon Oct 22, 2018 11:00 am - Best Answer
Copying formulas for a running total
Copying formulas for a running total
Last edited by Cliff S on Fri Oct 26, 2018 5:03 pm, edited 1 time in total.
Open Office 4.1.1 on Windows 10
Re: copying formulas for a running total
Formulas can be copied with
1. The Copy and Paste commands in the Edit menu or their keyboard shortcuts CTRL + C and CTRL V.
2. Clicking on the cell that contains the formula then doing click-hold on the little black box in the lower right corner of the cell and dragging it down.
3. Clicking on the cell that contains the formula then double clicking on the little black box in the lower right corner of the cell. This will fill the formula down as far as the neighboring column on the left is filled.
For a running total to work, the reference to the initial cell needs to be absolute. If the data to be summed start in A2, the formula in row 3 should be
1. The Copy and Paste commands in the Edit menu or their keyboard shortcuts CTRL + C and CTRL V.
2. Clicking on the cell that contains the formula then doing click-hold on the little black box in the lower right corner of the cell and dragging it down.
3. Clicking on the cell that contains the formula then double clicking on the little black box in the lower right corner of the cell. This will fill the formula down as far as the neighboring column on the left is filled.
For a running total to work, the reference to the initial cell needs to be absolute. If the data to be summed start in A2, the formula in row 3 should be
Code: Select all
=SUM($A$2:A3)OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: copying formulas for a running total
Just a quick suggestion based on my own usage of similar formulas: Make the first row something that will not change (eg: a heading).
If it is a heading, as long as it is text, then the sum will not be affected as text counts a 0 in the sum function.
If it is a heading, as long as it is text, then the sum will not be affected as text counts a 0 in the sum function.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.