find unique text and sum value

[nitr0]

I have problem with one function..i dont know how to do it and whether that is possible to do with formulas or macro.

I have column Name, where can be one name many times, next column state, subject which are useless this time and columns points and totals

I want to make function that do this:
Look to column A find name1 and all same names and sum the points together and put in column totals, then find name2 and do the same..

i attach the image..
http://img594.imageshack.us/img594/595/table2n.jpg

thanks for solution

 

[Andrew Poulsom]

Welcome to the Board.

That would be:

=SUMIF(A:A,A2,D:D)

in E2 copied down.

 

[nitr0]

thanks, so easy and i wasnt able to find that.

 

[Peter_SSs]

Welcome to the MrExcel board!

What about using Excel's built-in Pivot Table fearture? Results are shown in columns F:G.

Excel Workbook
	A	B	C	D	E	F	G
1	Name	Subject	State	Points		Sum of Points
2	John Smith	Biology	Completed	10		Name	Total
3	Sebastian Brown	Geography	Uncompleted	23		Joe Boll	43
4	Tim Bradley	Anathomy	Completed	143		John Smith	100
5	Joe Boll	Biology	Completed	43		Sebastian Brown	99
6	John Smith	Chemistry	Completed	56		Tim Bradley	199
7	John Smith	Physics	Uncompleted	34		Grand Total	441
8	Tim Bradley	Biology	Completed	56
9	Sebastian Brown	Anathomy	Uncompleted	76
10
Pivot table

For the future, you will get more help here if you post sample data directly in the forum so we can Copy/Paste it into our sheets for testing rather that having to type it manually liike I did this time. Here are some methods to investigate.

Excel jeanie
or
RichardSchollar’s beta HTML Maker
or
Borders-Copy-Paste