• Running Totals (2000/SR1-a)

    Author
    Topic
    #376168

    Hi All:
    I want to have a column of running totals next to a column of figures, so I need a formula like:
    =sum($B1:B1)
    =sum($B1:B2)
    =sum($B1:B3)
    – – – – – – – – –
    =sum($B1:Bn)

    Is there an easy way to get the fill-down feature to put these in my column. What I’ve been doing is make the first cell:

    1. =sum(Y:B1) where Y is not being used. The cell says “#Name?”
    2. Then I drag it down using the fill handle. The result is “#Name?” in all the cells.
    3. Then with the cells selected, I replace all “Y” with “$B1”.

    This works, but I’m wondering if there’s an easier way to put the formulas in all the cells.

    Thanks,

    Viewing 0 reply threads
    Author
    Replies
    • #615072

      Change the formula to =sum($b$1:b1) in the first cell.

      Then double click the fill handle at the bottom right of the cell.
      The column will autofill with the first refernece absolute (non-changing) and the second relative (auto incrementing).

      • #615114

        Ahh. Thank you so much. However, why do you double click the fill handle? I found that it seems to behave the same whether you drag it, or double click & then drag. Double click by itself didn’t do anything. Should it?
        Thanks again,

        • #615121

          The double Click should cause it to autofill in the list for you with out draging. This of course assumes that you are putting your formulas in an adjacent colomn

          HTH

          Peter

          • #615125

            Thank you. I didn’t realize that it only fills if the column is adjacent AND if each cell in the original column isn’t blank. Now I know. stupidme
            Thanks again.

      • #615154

        I never knew about double clicking the autofill cool.

        I would like to add a note here, as a help to those new to absolute referencing. Rather than trying to remember where the $ are placed in the formula, (because I always get it wrong), highlight the cells in the formula that need to be absolute and press the F4 function key at the top of the keyboard.

      • #615157

        Just another tip:

        Drag the fill handle *with your right mouse button* and you’ll get a context menu when you release with a number of nice options.

    Viewing 0 reply threads
    Reply To: Running Totals (2000/SR1-a)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: