**Question description:**

*This user has given permission to use the problem statement for this blog.*

i want to sum columns c thru k into column l in first line then automatically sum successive columns and lines in columns c thru k as numbers are added so that column l shows running total automatically.

Solved by M. H. in 39 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
03/05/2018 - 12:54

Hello! Welcome, Thanks for choosing Got It Pro-Excel

Excelchat Expert
03/05/2018 - 12:55

Let me see if I understood what you need

Excelchat Expert
03/05/2018 - 12:56

You want to sum all cells from column C to column K for each line?

User
03/05/2018 - 12:57

yes and then input numbers to successive lines and get a total automatically in line L

Excelchat Expert
03/05/2018 - 12:57

Was it as on cell L1 and L2?

Excelchat Expert
03/05/2018 - 12:59

you can use SUM function and select all cells you want to sum

Excelchat Expert
03/05/2018 - 12:59

and then copy cell L1 to the others below

User
03/05/2018 - 01:01

I want the number on L1 to be automatically added to the numbers I put into c thru k so the total is shown on L2 automatically as I input numbers on lines c3,4,5,6,etc.

Excelchat Expert
03/05/2018 - 01:03

L1 is the sum of cells C2 to K2?

Excelchat Expert
03/05/2018 - 01:03

Can you make an example, please?

Excelchat Expert
03/05/2018 - 01:05

I didn't understand

User
03/05/2018 - 01:06

no c1 has the number 2, d has no number, e has number 3, e has no number, f has number 5 then l would have an answer of 10

Excelchat Expert
03/05/2018 - 01:07

this answer on cell L1?

User
03/05/2018 - 01:09

c2 has a number of 6 -What would L have and what is the formula to get the new sum automatically into L when I input the number to c2.I want to continue this process for all successive lines.

Excelchat Expert
03/05/2018 - 01:10

"What would L have " you mean L1?

User
03/05/2018 - 01:11

yes Li then L2 and so on to L10000

Excelchat Expert
03/05/2018 - 01:12

on C2 you type 6, and the answer of L2 is the sum of C2 to K2 plus L1?

User
03/05/2018 - 01:13

yes and continue that same process for as many lines as I need

Excelchat Expert
03/05/2018 - 01:14

can you check on line 3?

Excelchat Expert
03/05/2018 - 01:14

pelase

Excelchat Expert
03/05/2018 - 01:14

please

Excelchat Expert
03/05/2018 - 01:14

I used a IF function to check if column C of that line has value. If it has value, then L is sumed, otherwise, L3 is blank

Excelchat Expert
03/05/2018 - 01:16

Is this formula OK? Or it was not what you need?

User
03/05/2018 - 01:17

yes that is what I want to do Please give me the formula so I can copy it down

Excelchat Expert
03/05/2018 - 01:17

=if(C2<>"",SUM(C2:K2)+L1,"")

Excelchat Expert
03/05/2018 - 01:17

you copy this formula on cell L2

Excelchat Expert
03/05/2018 - 01:18

and then you can paste to the lines above L2

User
03/05/2018 - 01:20

ok thank you very much I will play around with this to see if I can do what I want. Thank you very much and have a great day

Excelchat Expert
03/05/2018 - 01:20

Did work on your file?

Excelchat Expert
03/05/2018 - 01:20

You're welcome

Excelchat Expert
03/05/2018 - 01:20

have a nice day

Excelchat Expert
03/05/2018 - 01:21

If you need some changes, you can ask

User
03/05/2018 - 01:21

ok.thanks

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*