Sum of unique values in a list

[jpettit]

Hi there!

I'm looking to sum up a unique list. I've attached how i want the data to look.

AkonaTimekeeping2.xls
	A	B	C	D	E
1	Client	Billable		Client	TotalBillable
2	StudentA	$10.00		StudentA	$20.00
3	StudentB	$30.00		StudentB	$90.00
4	StudentA	$10.00		StudentC	$20.00
5	StudentB	$50.00
6	StudentC	$20.00
7	StudentB	$10.00
Sheet1

I want all the Student A, Student B, etc summed up in a new 'table'. I know i can use a pivot table for this, but if possible i would like to use a formula.

I would also like it dymanic, so that if a Student D, etc was added to COL A then it would automatically add it to the summed table (COl D).
Make any sense?

Thanks.

 

[jpettit]

This works for the summing part of my problem.
The part i need now is the addition of more clients that get added to the list. i.e. Student D

AkonaTimekeeping2.xls
	A	B	C	D	E
1	Client	Billable		Client	TotalBillable
2	StudentA	$10.00		StudentA	$20.00
3	StudentB	$30.00		StudentB	$90.00
4	StudentA	$10.00		StudentC	$20.00
5	StudentB	$50.00		"howdoigetStudentDhereautomatically?"	$-
6	StudentC	$20.00			$-
7	StudentB	$10.00			$-
8	StudentD	$40.00			$-
Sheet1

Thanks.

 

[just_jon]

See Aladin's posting to this thread.

 

[Aladin Akyurek]

You added a reply to the link Jon quoted:

"Can someone comment on a similar problem i have?:
Topic: http://www.mrexcel.com/board2/viewtopic.php?t=84902

My problem is less complex. Thanks."

In fact, yours is a bit more complex if you also want the student names in ascending order. If that's indeed the case, you'll need the revised Method 1 in:

http://www.mrexcel.com/board2/viewtopic.php?t=8659

You can also opt for a non-formula method: Pivot Tables for which you can define a dynamic named range.