Calculate sum in a column based on a condition in another column

[Tejas Kore]

Hello Friends,
I want to find sum in a column based on the criteria in another column. Here is a sample data:
A B
ABC 2
ABC 2
DEF 3
DEF 3
DEF 3

I want output like. How can this be achieved using excel formula:

ABC 4
DEF 9

 

[JamesCanale]

For this one, it's helpful to know your version of excel. For 365.

MrExcelPlayground2.xlsm
	A	B	C	D	E
1	ABC	2		ABC	4
2	ABC	2		DEF	9
3	DEF	3
4	DEF	3
5	DEF	3
Sheet36

Cell Formulas
Range	Formula
D1:D2	D1	=UNIQUE(A1:A5)
E1:E2	E1	=SUMIFS($B$1:$B$5,$A$1:$A$5,D1)
Dynamic array formulas.

For older versions,

MrExcelPlayground2.xlsm
	A	B	C	D	E
11	ABC	2		ABC	4
12	ABC	2		DEF	9
13	DEF	3
14	DEF	3
15	DEF	3
Sheet36

Cell Formulas
Range	Formula
E11:E12	E11	=SUMPRODUCT($B$11:$B$15,--($A$11:$A$15=D11))

You might have sumifS, but not unique, so mix and match...

 

[Tejas Kore]

For this one, it's helpful to know your version of excel. For 365.

MrExcelPlayground2.xlsm
	A	B	C	D	E
1	ABC	2		ABC	4
2	ABC	2		DEF	9
3	DEF	3
4	DEF	3
5	DEF	3
Sheet36

Cell Formulas
Range	Formula
D1:D2	D1	=UNIQUE(A1:A5)
E1:E2	E1	=SUMIFS($B$1:$B$5,$A$1:$A$5,D1)
Dynamic array formulas.

For older versions,

MrExcelPlayground2.xlsm
	A	B	C	D	E
11	ABC	2		ABC	4
12	ABC	2		DEF	9
13	DEF	3
14	DEF	3
15	DEF	3
Sheet36

Cell Formulas
Range	Formula
E11:E12	E11	=SUMPRODUCT($B$11:$B$15,--($A$11:$A$15=D11))

You might have sumifS, but not unique, so mix and match...

I have Microsoft® Excel® for Microsoft 365 MSO (16.0.14026.20202) 32-bit . The first solution ran seamlessly !!

 

[Fluff]

I have Microsoft® Excel® for Microsoft 365 MSO (16.0.14026.20202) 32-bit . The first solution ran seamlessly !!

I would suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)