Hi,

I want to set a formula by which every cell of a particular column will be the sum of values of some previous columns of the corresponding columns. For example, let's say the SUM column will be column 'M'. So, M1=B1+C1+D1+E1+F1+G1+H1+I1+J1+K1+L1.

M2=B2+C2+D2+E2+F2+G2+H2+I2+J2+K2+L2.

M3=B3+C3+D3+E3+F3+G3+H3+I3+J3+K3+L3 likewise......

That means I actually need M=B+C+D+E+F+G+H+I+J+K+L for all rows.Please help me, I am new to excel and can't set the formula.

1 - In M1 enter =SUM(B1:L1)

2 - Press Enter

3 - Click in M1 and move your mouse over to the small square in the lower right corner of the cell.

4 - When the cursor turns into a plus sign, click and drag the formula down as far as you need it.It will update the row numbers automagically.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you buddy...........

Ask Your Question

Weekly Poll