Using unique-function to add up values

Hey guys,

I am splitting a column according to it's unique values:

[C, ia, ic] = unique(Location)

Which gives me (examplified):

C/ia/ic:

Location1   1205    8
Location2   9       8
Location3   387     2
Location4   45      2
Location5   653     8
Location6   59      8
Location7   3       1
Location8   1037    1

etc.. numbers may not match..

Now I have another colum containing DiffTime(seconds):

DiffTime:

0
23853
16835
12900
14869
40810
11700
10201

How can I add up DiffTime for each unique Location?

So that i get DiffTimeTotal for Location1, Location2, ...

Thanks for your help!!

Answer 1

[Matt J]

accumarray(ic, DiffTime)

[Lukas Netzer]

Thanks!

Answer 2

[Matt J]

Possibly faster:

totals = splitapply(@sum, DiffTime, findgroups(Location))