Sum Values based on Column Value

[Elliot76]

Hey All,

I am trying to sum together values in a column based on a string value in column A.
I have something similar to the table below and wish group together the strings in column A and sum the values in column B to give me a combined table.

Input:

Column A	Column B
TestA	5
TestA	1
TestA	3
TestB	1
TestB	2
TestC	5

Result (trying to build)

Column A	Column B
TestA	9
TestB	3
TestC	5

 

[SunnyAlv]

Try This

=HSTACK(UNIQUE($A$2:$A$7),SUMIF($A$2:$A$7,UNIQUE(A2:A7),B2:B7))2

 

[Elliot76]

Try This

for array Formula

=HSTACK(UNIQUE($A$2:$A$7),SUMIF($A$2:$A$7,UNIQUE(A2:A7),B2:B7))2

View attachment 104278

Sorry, should have stated that I would like to write this as a macro so the user has a button to press on the main worksheet!

 

[SunnyAlv]

Sorry, should have stated that I would like to write this as a macro so the user has a button to press on the main worksheet!

Which row do you want to put the results of the macro in?

 

[Elliot76]

Which row do you want to put the results of the macro in?

It would be useful if I could have the results on a new sheet to the original results can be seen, if that makes sense?

 

[Elliot76]

UPDATE:
I now have 2 columns I wish to check to give me a summed table as per the below:

I need to find the unique values within Columns A & C and sum column D to give me a final result.

Input:

FFIAT Fund Import TEST.xlsm
	Q	R	S	T
1	ColumnA	Column B	ColumnC	ColumnD
2	TestA	gfdg	hello	1
3	TestA	fgbv	hello	2
4	TestA	bt	hello	3
5	TestA	bv	world	4
6	TestA	fb	world	5
7	TestA		world	6
8	TestB	rbv	hello	1
9	TestB	b	world	1
10	TestB	bvnf	world	2
11	TestC	vc	hello	1
12	TestC	hfd	hello	2
13	TestC	gfdg	hello	3
14	TestC	sdfg	world	4
Test

Output:

FFIAT Fund Import TEST.xlsm
	U	V	W
1	ColumnA	ColumnB	ColumnC
2	TestA	hello	6
3	TestA	world	15
4	TestB	hello	1
5	TestB	world	3
6	TestC	hello	6
7	TestC	world	4
Test

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sum column based on multiple criteria
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.