Question description:
This user has given permission to use the problem statement for this
blog.
Spreadsheet has a column with cells containing AB1 or WA2, etc that corresponds with the next column associated number. Such as AB1 corresponds to 21, while another AB1 corresponds to 106. I want a 3 column that will take all AB1 and total the corresponding number and total
Solved by F. F. in 43 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/08/2018 - 07:10
Hello
User
08/08/2018 - 07:10
hi
User
08/08/2018 - 07:11
are you there
Excelchat Expert
08/08/2018 - 07:11
Yes I am>
Excelchat Expert
08/08/2018 - 07:11
Can you provide your sheet?
Excelchat Expert
08/08/2018 - 07:13
Hello
User
08/08/2018 - 07:15
here you go
[Uploaded an Excel file]
User
08/08/2018 - 07:18
I want to take all AB1 or AB3, etc in column a, use corresponding number in column b and total in each line in column c (column may have same number on several lines
Excelchat Expert
08/08/2018 - 07:18
I can't get the attached file
Excelchat Expert
08/08/2018 - 07:19
there is a problem with downloading
User
08/08/2018 - 07:19
do you understand from the description what I need
Excelchat Expert
08/08/2018 - 07:19
yes
User
08/08/2018 - 07:20
can you help with just that information
Excelchat Expert
08/08/2018 - 07:21
Can you please insert the sheet at the preview.
User
08/08/2018 - 07:23
can you see this
Excelchat Expert
08/08/2018 - 07:23
yes
User
08/08/2018 - 07:24
Obviously the answer is 30 for C1 and C2 but i need a formula so when the lines are sorted differently i still have that number
Excelchat Expert
08/08/2018 - 07:25
You can get the total using the sumif formula
User
08/08/2018 - 07:26
can you show me
Excelchat Expert
08/08/2018 - 07:28
the total is at col C
User
08/08/2018 - 07:30
i tried on a simple spreadsheet and it's not working
User
08/08/2018 - 07:30
also, will i have to write in the formula every single option?
Excelchat Expert
08/08/2018 - 07:32
Just insert the formula at the first cell and drag down.
User
08/08/2018 - 07:33
=SUMIF($A$6:$A$126,A1,$B$6:$B$126)
User
08/08/2018 - 07:34
mine comes up 0 every time
Excelchat Expert
08/08/2018 - 07:34
At which cell you insert this formula ???
User
08/08/2018 - 07:36
i put it in c6
Excelchat Expert
08/08/2018 - 07:36
Why you insert A1 at the formula
Excelchat Expert
08/08/2018 - 07:37
insert A6
Excelchat Expert
08/08/2018 - 07:37
Or you want the criteria form A1
User
08/08/2018 - 07:41
so i will need to list every option in column a with the total lines. is this correct?
Excelchat Expert
08/08/2018 - 07:43
Can you attach your sheet again or copy and paste it at the view.
User
08/08/2018 - 07:44
there you go
Excelchat Expert
08/08/2018 - 07:45
And you need the total for each Id ??
User
08/08/2018 - 07:45
yes
Excelchat Expert
08/08/2018 - 07:48
Like this >>>
User
08/08/2018 - 07:49
Great! You did my job for me....haha. I will copy the formula for future use. Thank you so much for the help.
Excelchat Expert
08/08/2018 - 07:51
You can download this file if you want.
User
08/08/2018 - 07:51
how
Excelchat Expert
08/08/2018 - 07:52
From file menu - download as - xlsx
Excelchat Expert
08/08/2018 - 07:52
Got it ??
User
08/08/2018 - 07:53
Yes! Rate the Expert: 10+
Excelchat Expert
08/08/2018 - 07:53
Thank you
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.