Extract info based on Name
In C1 enter =SUMIF(A1:A6,"Store " & ROW(),B1:B6)
Drag/copy to C4
BTW Store 1 is $103
Gord Dibben Microsoft Excel MVP
On Fri, 22 Jul 2011 02:53:34 -0700 (PDT), khers
wrote:
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
|