Forum Discussion

Brittany3-67's avatar
Brittany3-67
Copper Contributor
Dec 04, 2019

copying autosum for adding up numbers in row but locking in first cell

HI

 

I'm adding up a row and working out a percentage of the sum e.g. Cell E7 = SUM(B7:D7)*9% but when I copy the formula across the row I want it to lock in the first cell its adding from e.g. for the next cell F7 I want it to add up Sum(B7:E7)*9% i.e. it always adds from B7.  How do I lock in the first cell in the formula when I copy it across it starts with that first cell (in this case B7)

 

Cheers, Tom

excel

1 Reply

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Dec 04, 2019

    Hello Brittany3-67,

     

    That could be:

    = SUM($B7:D7)*9%

     

    P.S. In the formula, click "B7" and press F4 to cycle through absolute and relative references.

Resources