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
download the file
User
23/10/2017 - 09:19
hmmm
User
23/10/2017 - 09:19
copying ddnt work
User
23/10/2017 - 09:19
i dont see a download
Excelchat Expert
23/10/2017 - 09:19
download the file at the top of this chat
Excelchat Expert
23/10/2017 - 09:19
the same file you attach
Excelchat Expert
23/10/2017 - 09:20
that is your file
Excelchat Expert
23/10/2017 - 09:20
[Uploaded an Excel file]
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.
