| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to find matching criteria in 1 column, then add amounts in a
Hi,
Trying to match criteria in one column and then add amounts that are in a second column. Need to find all in column A that match, then add amounts in column B for matching criteria. Thoughts? Thinking maybe better to try in Access? A B 1 8268001100 144.78 2 8268001100 12133.09 3 8266012100 640.84 4 8266012100 404.11 5 8206011600 122.14 6 8206011600 1787.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find if there is a matching number in another column | Excel Discussion (Misc queries) | |||
| find a cell matching separate column and row values | Excel Worksheet Functions | |||
| How can find a value using two different matching criteria? | Excel Worksheet Functions | |||
| matching dupliclates and then looking up the corresponding amounts | Excel Discussion (Misc queries) | |||
| Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
Threaded Mode
