Sum all cells in column B for all the cells that have the same text in column A

[ygar]

Hi,

I need a formula that will add the values in column B for each member (Member names are sorted alphabetically):

Column A - Members	Column B	Sum (Required result)
Member 1	4	10
Member 1	6
Member 2	4	4
Member 3	3	5
Member 3	1
Member 3	1

 

[jasonb75]

Try

=IF(A2=A1,"",SUMIFS(B:B,A:A,A2))

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C
1	Column A - Members	Column B	Sum (Required result)
2	Member 1	4	10
3	Member 1	6
4	Member 2	4	4
5	Member 3	3	5
6	Member 3	1
7	Member 3	1
Master sheet

Cell Formulas
Range	Formula
C2:C7	C2	=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A:A,A2,B:B),"")

 

[ygar]

Yes, that works. thanks! How do I mark it as a correct answer?

Try

=IF(A2=A1,"",SUMIFS(B:B,A:A,A2))

 

[ygar]

How about

+Fluff New.xlsm
	A	B	C
1	Column A - Members	Column B	Sum (Required result)
2	Member 1	4	10
3	Member 1	6
4	Member 2	4	4
5	Member 3	3	5
6	Member 3	1
7	Member 3	1
Master sheet

Cell Formulas
Range	Formula
C2:C7	C2	=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A:A,A2,B:B),"")

Yes this one also works. Thanks!

 

[Fluff]

Glad we could help & thanks for the feedback.