sum results based on a reference

M

Mauro

I have column A with several repeating references (e.g: 1, 2, 3,4,3,2,4,5,2,
etc), I need to be able to sum the values in column B that match the specific
reference.
e.g.:
A B
1 25
2 14
3 18
1 20
3 25

Therefore, if I am looking at sum of all values referred from "1", my total
is 45 (25+20).
Can someone help? my columns A and B can go to hundreds of rows, and no more
than 30 to 50 references.

thank you,

Mauro
 
O

Otto Moehrbach

In C1, enter this formula and drag it down. HTH Otto

=SUMIF($A$1:$A$5,A1,$B$1:$B$5)
 

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

Cumulative formula for word table 0
Sum Values from different column 1
Sum of values in column A based on 0/1 of column B 2
List all tables, including document structure 0
Linking Child Timelines to Multiple Parents 0
15 minute data to daily data 1
SUM Q 2
Count Dates in a range based on Column Header Id without using sum-product 1

Top