Need to find matching criteria in 1 column, then add amounts in a

H

HeatherJ

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
 
F

Fred Smith

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

John C

=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)
 
G

Glenn

HeatherJ said:
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
Click to expand...


Look at this:

http://www.contextures.com/xlFunctions01.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

a formula to search for names in columns and then add the figures 5
EXCEL - Meet 2 criteria, then find next case of third criteria 3
Find matching records in two tables using mulitiple criteria 1
Sum cells using criteria from a row and a column 2
Combining IF, ANd and SUM functions in a formula 15
matching 1 to 1 and 1 with variations... 3
if meets criteria add 1 2
Matching column criteria in a one to many relationship 8

Top