find unique text and sum value

nitr0

New Member
Joined
Jul 22, 2010
Messages
9
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
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
54,272
Office Version
  1. 365
Platform
  1. Windows
Welcome to the MrExcel board!

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

Excel Workbook
ABCDEFG
1NameSubjectStatePointsSum of Points
2John SmithBiologyCompleted10NameTotal
3Sebastian BrownGeographyUncompleted23Joe Boll43
4Tim BradleyAnathomyCompleted143John Smith100
5Joe BollBiologyCompleted43Sebastian Brown99
6John SmithChemistryCompleted56Tim Bradley199
7John SmithPhysicsUncompleted34Grand Total441
8Tim BradleyBiologyCompleted56
9Sebastian BrownAnathomyUncompleted76
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
 
Last edited:
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,580
Messages
5,832,584
Members
430,144
Latest member
bruno92

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top