Trouble sorting with result

M

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.
 
M

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.
 
M

MIKE

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

mike.
 
Top