Hey, I haven't really worked with excel in a while but I know the basic functions so I am not a complete idiot. However, I am stuck here. I have 2 columns, one is a store name and the other is a price. How would I write a function to give me the sum of one of the stores. Example:


BC-------------$10
BC-------------$8
N---------------$10
BCG----------$5
BC------------$7
B--------------$6

I want to write a function in a separate column that adds all of the BC etc.

Thanks for your help!

Ian