# Excel - COLUMN Function Problem - Expert Solution

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
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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.