Trouble sorting with result

[Mike]

Need help from someone who is familiar with sorting things
in catergories.

Here's my case ... I want to know how I can use a seperate
collum for each like below ...
A1 = 45|B1 = HK
A2 = 25|B2 = JK
A3 = 40|B3 = HK
A4 = 10|B4 = SP
A5 = 15|B5 = JK
A6 = 82|B6 = SP

and so on ... and then get the sum on the last row or
something with the sum of numbers correspoding with the
letter.

A7 = 85HK
A8 = 40JK
A9 = 92SP
(maybe its not possible to get the letter in the same
cell, maybe it has to be beside it in another cell.)

I wold really appreciate if you could help me.I am still
trying my best to learn the ropes in excel.
Thank you very much.

 

[Frank Kabel]

Hi Mike
one way:
in your example you can try the following:
A7: insert HK
B7: insert =SUMIF($B$1:$B$6,A7,$A$1:$A$6)
repeat this for A8:B9

another way could be the creation of a pivot table (look at
http://www.cpearson.com/excel/pivots.htm for some instructions)

HTh
Frank

 

[Mike]

Use SUMIF and CONCATENATE function to add and then combine
the two together. For example,

A7= CONCATENATE(SUMIF(B1:B6,"HK",A1:A6),"HK"))

Unless you have to, don't hardcode the "HK" - put it in
cell B7 and refer to it.

 

[MIKE]

Wow ... thats exactly what I was looking for. Thank you
very much, and yes I will also look into pivot tables.

mike.