Adding total points from multiple rows

[Excelself]

Hi there!

I am trying to add the total points earned from a student. However, student ID column contains duplicate ID numbers. What I want to do is to create another column showing the student ID and the total points earned.

Thank you

StudId TOTAL POINTS
1619419 0.3
1619419 1
1619419 0.3
1619419 0.3
1784021 0.3
1784021 0.3
1784021 0.3
1775820 0.2
1775820 0.2
1775820 1
1775820 1
1775820 1
1775820 1
1792483 0.3
1792483 1
1740471 0.3
1740471 0.3
1740471 0.3
1740471 0.3

 

[Fluff]

How about

Book1
	A	B	C	D	E
1	StudId	TOTAL POINTS		Studid	Total
2	1619419	0.3		1619419	1.9
3	1619419	1		1784021	0.9
4	1619419	0.3		1775820	4.4
5	1619419	0.3		1792483	1.3
6	1784021	0.3		1740471	1.2
7	1784021	0.3
8	1784021	0.3
9	1775820	0.2
10	1775820	0.2
11	1775820	1
12	1775820	1
13	1775820	1
14	1775820	1
15	1792483	0.3
16	1792483	1
17	1740471	0.3
18	1740471	0.3
19	1740471	0.3
20	1740471	0.3
Audit

Cell Formulas
Range	Formula
D2	=IFERROR(INDEX(A$2:A$20,MATCH(0,INDEX(COUNTIF(D$1:D1,A$2:A$20),0),0)),"")
E2	=SUMIF($A$2:$A$20,D2,$B$2:$B$20)

 

[Excelself]

It worked perfectly. One more question if you do not mind. I am using Excel 2016 and I cannot used more than 6 isnumbersearch functions. Is there a different function that would support more than 6? Please let me know,

Thank you for you time.

 

[Fluff]

Depends on what you are trying to do. I suggest you start a new thread giving some details.

 

[Excelself]

Will do.

Much appreciated.

 

[Fluff]

You're welcome & thanks for the feedback