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
:
< Then drag and drag again> code> = $ A2 + B $ 1
then drag it down.
Comments
Post a Comment