Summing a column value with each row value in excel -
I want to add a column value to each row value in Excel. I will insert an image of my spreadsheet but apparently I need 10 reputation to do this. In fact, this would be the following: cell B2 = B1 + A2 cell B3 = B1 + A3 cell B4 = B1 + A4 and so on. I can do this for a column but I need to repeat it in each column. Can anyone tell me which formula / method can I use? Dragging does not help. Thank you. For cell B2 : code> = $ A2 + B $ 1 then drag it down.