View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
khers khers is offline
external usenet poster
 
Posts: 3
Default Extract info based on Name

Hello
I have two colons. Colomn A has the name of the stores I have
purchased from, and Colomn B has the ammount of money I have paid.

A B
Store 1 $ 20
Store 2 $ 3
Store 3 $ 25
Store 1 $ 83
Store 4 $ 90
Store 2 $ 18

What I need is to Sum up how much I have spent in each Store, so I
get :

Store 1 $ 113
Store 2 $ 21
Store 3 $ 25
Store 4 $90

Thanks in advance
Khers