I have a formula in cell B8 “=((A2*B2)+(A3*B3)+(A4*B4)+(A5*B5)+(A6*B6))
” that I would like to copy that formula to other cells (C8,D8,E8…) without changing the cell reference of A2 to A6. Is there a way to do this?
I am enclosing a copy of the spreadsheet.