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 |
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 |