Finding multiple entries and ignoring others ??

I have a table of figures that are generated by then users input

I could end up with a table of text like this in a column 1 to 26 row A -B
Row A Row B
1) LE3203 10.00
2) LE3203 20.00
3) LE3203 30.00
4) LE3203 35.00
5) LE0001 10.00
6) LE0001 20.00
7) LE0001 30.00

AND SO ON

what I want to do is not count how many times a text appears (le3203) but to put it in another list ONCE so I would end up with a list like this

text, number of times it appeares total of row b that has same text

Row A Row B Row C

1) LE3202 4 95.00
2) LE0001 3 60.00

I know how to use the sumif, but how do i get the First line to appear ONCE even if there are several listings for it.

Hope I have explained this ok

Thanks ion advance

MaDbrIt