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