On Jul 22, 10:53*am, 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

EXCEL 2007

Assuming your stores are in column A (A1 to A6)

- and your money paid is in column B (B1 to B6)

- then:-

=SUMIF(A1:A6,"Store1",B1:B6)

Chnage the store number as required.