# Excel - COLUMN Function Problem - Expert Solution

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
Excelchat Expert 08/08/2018 - 07:13
Hello
User 08/08/2018 - 07:15
here you go
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
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
User 08/08/2018 - 07:51
how
Excelchat Expert 08/08/2018 - 07:52
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.

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.