sorting data

[powelly]

Sorry if this has been asked before, but ive searched to no avail, as I
dont really know what to call the question.

i have the following

A B
4 2
1 5
2 3
1 6
4 3


Can I automate the sorting of this data so that for each value in
column A the Values in Column B are totaled, ie it becomes

A B
1 11
2 3
4 5


Thanks

Andy

 

[Dave Peterson]

You could either sort your data by column A and then Data|subtotals or you could
add headers and do Data|pivottable.