# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i want to create a column that automatically totals all cells with a common row value, and possibly also sort these types of columns by the value of another row value
Solved by S. A. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/10/2017 - 09:00
hi
Excelchat Expert 23/10/2017 - 09:01
how can i help
User 23/10/2017 - 09:01
hello
User 23/10/2017 - 09:01
i want to type values down in a column
User 23/10/2017 - 09:01
in this case like i have here in column f
Excelchat Expert 23/10/2017 - 09:02
ok
Excelchat Expert 23/10/2017 - 09:02
and ...
User 23/10/2017 - 09:02
and then, in column E, the total for any cells with that title will appear
Excelchat Expert 23/10/2017 - 09:02
ok
Excelchat Expert 23/10/2017 - 09:02
countif()
User 23/10/2017 - 09:03
so for instance where i typed "100" in E4, then the totals for cells B3:B5 appear
Excelchat Expert 23/10/2017 - 09:04
sumif()
Excelchat Expert 23/10/2017 - 09:04
sorry
Excelchat Expert 23/10/2017 - 09:04
the formula is
Excelchat Expert 23/10/2017 - 09:04
=SUMIF(C2:C14,F3,B2:B14)
Excelchat Expert 23/10/2017 - 09:05
are you there
User 23/10/2017 - 09:06
yes
User 23/10/2017 - 09:06
sorry i was just trying it out
User 23/10/2017 - 09:06
whoa that is perfect thank you
Excelchat Expert 23/10/2017 - 09:06
Is there anything else you want to know regarding this issue?
User 23/10/2017 - 09:07
yes that was the first half of my problem
User 23/10/2017 - 09:07
the second half is that I need many column-pairs like E and F, sorted by another value. that value will be the month
Excelchat Expert 23/10/2017 - 09:07
the second ..
User 23/10/2017 - 09:09
so, is it possible as i am adding these month values in column D, that they automatically appear in the appropriate columns E-J?
User 23/10/2017 - 09:11
i guess what im saying is that now i dont even want to type anything in column F, H, or J, i only want to type in column D and have excel do the rest for me
Excelchat Expert 23/10/2017 - 09:13
what columns you need to edit
Excelchat Expert 23/10/2017 - 09:14
try this
User 23/10/2017 - 09:14
im listening
Excelchat Expert 23/10/2017 - 09:15
in the view
Excelchat Expert 23/10/2017 - 09:15
if you need any editing on it
User 23/10/2017 - 09:16
wow thats a doozie of a formula
Excelchat Expert 23/10/2017 - 09:17
anything else
User 23/10/2017 - 09:18
i'm tyying to wrap my brain around what you type here
Excelchat Expert 23/10/2017 - 09:18
ok
User 23/10/2017 - 09:18
oh heck i guess i can copy pastethis whole thing
User 23/10/2017 - 09:18
cuz im almost out of time
Excelchat Expert 23/10/2017 - 09:18
User 23/10/2017 - 09:19
hmmm
User 23/10/2017 - 09:19
copying ddnt work
User 23/10/2017 - 09:19
Excelchat Expert 23/10/2017 - 09:19
Excelchat Expert 23/10/2017 - 09:19
the same file you attach
Excelchat Expert 23/10/2017 - 09:20
Excelchat Expert 23/10/2017 - 09:20
Excelchat Expert 23/10/2017 - 09:21
got it
Excelchat Expert 23/10/2017 - 09:22
?
Excelchat Expert 23/10/2017 - 09:25
are you there

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.