Search code examples
excelexcel-2011

Summing a column value with each row value in excel

I want to add a column value with each row value in an excel. I would insert an image of my spreadsheet but apparently I need 10 reputation to do that.

Basically, it would be the following:

Cell B2 = B1+A2

Cell B3 = B1+A3

Cell B4 = B1+A4

and so on.

I can do that for one column but I need to replicate it in each column.

Can anyone please tell me what formula/method I could use? Dragging doesn't help.

Thanks.

Solution

  • For cell B2 put: 

    =$A2 + B$1

    Then drag down, and then drag across.