Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default Extract info based on Name

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,045
Default Extract info based on Name

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


Take a look at Pivot Tables.

Label your columns. Then Insert/Pivot table and drag "Store Name" to the rows area; and Payments to the Data or Values area.
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 86
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default Extract info based on Name

On Jul 22, 5: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


Try Pivot Tables. Depending on your version of Excel the way to
create varies. A quick search on the net will provide instructions.

Robert Flanagan
http://www.add-ins.com
productivity add-ins and downloadable books on VB macros for Excel
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract info from one sheet to another Kim Excel Worksheet Functions 2 March 15th 08 02:30 PM
Macro to put info into certain columns based on info in another co Studebaker Excel Discussion (Misc queries) 1 December 4th 07 06:27 PM
varying validation info based on preceding info georgejl Excel Discussion (Misc queries) 1 November 9th 06 11:31 PM
Extract some info from a string mathew Excel Discussion (Misc queries) 2 October 11th 06 10:02 PM
Would it be possible to extract info from this site? IntricateFool Excel Discussion (Misc queries) 3 September 14th 06 05:55 PM


All times are GMT +1. The time now is 09:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"