Group similar cells and show the sum of values

[BakirDZ]

Hello everyone, hope you're doing well

I have this table and I want to group the values for each letter like this :

of course the data I want to use this method for is not as simple and small as this example LOL

 

[Peter_SSs]

Why not use Excel's built-in Subtotal feature (on the Data ribbon tab)

When you subtotal you get this

24 02 19.xlsm
	A	B
1	Letter	Value
2	A	5
3	A	12
4	A	14
5	A Total	31
6	B	7
7	B	10
8	B Total	17
9	C	1
10	C	4
11	C Total	5
12	Grand Total	53
Subtotal 1

Cell Formulas
Range	Formula
B5	B5	=SUBTOTAL(9,B2:B4)
B8,B11	B8	=SUBTOTAL(9,B6:B7)
B12	B12	=SUBTOTAL(9,B2:B10)

.. but if you only want the totals, click the '2' button at the top left to produce this

 

[BakirDZ]

Thank you for your help Peter_SSs, It's not exactly what I want to do, I have a long list of products in column A and some are duplicates.. I have the quantities for those products in column B what I'm trying to do is to group similar product names in one line and the quantity is the sum of all the quantities of that product

from this:

to this:

this example is more accurate.

 

[Peter_SSs]

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

Try something like this then

24 02 19.xlsm
	A	B	C	D	E
1
2	product1	2		product1	20
3	product2	5		product2	37
4	product3	100		product3	125
5	product1	5
6	product1	8
7	product3	14
8	product3	11
9	product2	32
10	product1	5
Group and Sum

Cell Formulas
Range	Formula
D2:D4	D2	=UNIQUE(A2:A10)
E2:E4	E2	=SUMIF(A2:A10,D2#,B2:B10)
Dynamic array formulas.

 

[BakirDZ]

I'm not sure if I know what that is, thanks for your help !

 

[Peter_SSs]

I'm not sure if I know what that is

If you mean XL2BB, it is an Add-In that lets you produce mini sheets like the one I posted in my previous post. They can easily be copied from the forum to a worksheet of your own. The link in that post (or in my signature block below) has more information.

thanks for your help !

You're welcome. Thanks for the follow-up.