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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to find matching criteria in 1 column, then add amounts in a
In C1, try this:
=sumif(A:A,A1,B:B) Copy down as needed. The other option is a Pivot Table. It will create a very nice summary for you. Regards, Fred. "HeatherJ" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to find matching criteria in 1 column, then add amounts in a
=SUMIF(A2:A100,yourvalue,B2:B100)
This will look in your first column (A2:A100), find any that match your value, and sum the respective value from your second column (B2:B100) -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "HeatherJ" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to find matching criteria in 1 column, then add amountsin a
HeatherJ wrote:
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 Look at this: http://www.contextures.com/xlFunctions01.html |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to find matching criteria in 1 column, then add amounts in a
Hi,
Try Data Consolidate -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "HeatherJ" wrote in message ... 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 |
Reply |
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 |