Adding up column based on value of different column??

[tombe]

Hi,

am pretty new to this and was wondering if someone can help me with this please. Basically i have i get a list of numbers, different everyday, and i must go through and match numbers i col A and adding with what it corresponds with in col B, for example:

AT006462 34
AT006461 32
AT006457 21
AT006463 6
AT006458 7
AT006463 4
AT006460 23
AT006457 234
AT006462 87
AT006459 213
AT006459 12
AT006460 56
AT006461 345
AT006458 78


So AT006462 appears twice and its total is (34+87) 121. Is there any way i can add up col B for each number in col A. If that makes sense.

It's really been bugging me and currently i can get upto 1000 numbers i have to add up manually.

Thanks

Tom

 

[Jonmo1]

Try the SUMIF function

=SUMIF(A1:A1000,"AT006462",B1:B1000)


You can use a cell reference for the "AT006462" part

=SUMIF(A1:A1000,C1,B1:B1000)

C1 = AT006462


Hope that helps.