how to total quantities of repeated numbers in a new column

[Tyobes]

Hello

I want to know how can calculate the total of qté (B column) of repeated/duplicate numbers of column A in a new column (C) and concat the numbers (D column) of these duplicate values in a new column (E) like the picture

Example: the number 67813 is duplicated twice, first time with 27 and second one with 4, so I want to have the total (27+4) in a new cell (C2 and C6); same thing with their Financial Number, both of them should be concat with "/"

 

[Fluff]

You can use the sumifs function for that. SUMIFS Function

 

[Tyobes]

You can use the sumifs function for that. SUMIFS Function

My picture is just a example, I don't think SUMIFS will work with a lot of duplicates

 

[Fluff]

I don't think SUMIFS will work with a lot of duplicates

Why not?

 

[Tyobes]

Why not?

I have more than 5000 numbers in a column A, and more 84 duplicated value, not just 67813 wich is duplicated, so for my case if SUMIFS will work fo me how can I work with it
SUMIFS(

• sum_range - for my case B2:B78
• range1 - The first range to evaulate.
• criteria1 - The criteria to use on range1

 

[Fluff]

You can just use

=SUMIFS(B:B,A:A,A2)

 

[Tyobes]

You can just use

=SUMIFS(B:B,A:A,A2)

Great thanks, I didn't think it would work; but what about the concatenateIFS, I know it's doesn't exist on excel so how to deal with it ?

 

[Fluff]

I've no idea what you mean.