| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and add
Hi,
I have data in 2 columns ex. Col 1: Name, Col 2: Amount A name can appear multiple times with same or different amounts. Ex: Col 1 : A, C, A, A,A ; Col 2: $10, $30, $40, $20, $30 Can someone suggest if there is a function in excel 2003 i can use with the data from Col 1 and Col 2 and by giving a search entry "A" i should get the sum of all corresponding A entries in Column 2 i.e. $100 Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search and add
Try something like this...
=SUMIF(A2:A6,"A",B2:B6) Or, using a cell to hold the criteria: D2 = A =SUMIF(A2:A6,D2,B2:B6) -- Biff Microsoft Excel MVP "Vishnu" wrote in message ... Hi, I have data in 2 columns ex. Col 1: Name, Col 2: Amount A name can appear multiple times with same or different amounts. Ex: Col 1 : A, C, A, A,A ; Col 2: $10, $30, $40, $20, $30 Can someone suggest if there is a function in excel 2003 i can use with the data from Col 1 and Col 2 and by giving a search entry "A" i should get the sum of all corresponding A entries in Column 2 i.e. $100 Thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search and add
SumIf will do what you are asking...
-- HTH... Jim Thomlinson "Vishnu" wrote: Hi, I have data in 2 columns ex. Col 1: Name, Col 2: Amount A name can appear multiple times with same or different amounts. Ex: Col 1 : A, C, A, A,A ; Col 2: $10, $30, $40, $20, $30 Can someone suggest if there is a function in excel 2003 i can use with the data from Col 1 and Col 2 and by giving a search entry "A" i should get the sum of all corresponding A entries in Column 2 i.e. $100 Thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search and add
It worked..Thanks
"Jim Thomlinson" wrote: SumIf will do what you are asking... -- HTH... Jim Thomlinson "Vishnu" wrote: Hi, I have data in 2 columns ex. Col 1: Name, Col 2: Amount A name can appear multiple times with same or different amounts. Ex: Col 1 : A, C, A, A,A ; Col 2: $10, $30, $40, $20, $30 Can someone suggest if there is a function in excel 2003 i can use with the data from Col 1 and Col 2 and by giving a search entry "A" i should get the sum of all corresponding A entries in Column 2 i.e. $100 Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file search or search files | Excel Discussion (Misc queries) | |||
| Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
| Functions (search within search result) | Excel Worksheet Functions | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Linear Mode
