Forum Discussion
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...
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.