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