Not a very good title I know, but I'm new to excel and still picking up on the terminology!

BP01 5
BP02 2
BP03 1
BP01 7
BP01 3
BP02 5


I need some way of looking through all the cells and obtaing a sum for all the values that are linked to BP01 so that it can be put into a chart. So in this case BP01 would equal 15, BP02 would equal 7 etc etc.