formula help - maybe vlookup, not sure

[Guest]

here's the logic. i have an ID which could have anywhere from 1-5 entries.
for each ID, i want to sum what's in the column next to it. for example -
column a column b column C
ID 123 $20 $44
ID 123 $24
ID 125 $23
ID 125 $12
ID 111 $10
is there a way to look at whats in column A and do the sum for whats in
column B and put that total in column C?

 

[PCLIVE]

One way:
=SUMIF(A1:A10,"ID 123",B1:B10)

HTH,
Paul

 

[Guest]

One way - use SUMIF
In C1: =SUMIF(A:A,A1,B:B)
Copy down

 

[Bernie Deitrick]

Assuming you have headers in row 1, enter this into cell C2, and copy down to match your table:

=IF(COUNTIF($A$2:A2,A2)=1,SUMIF(A:A,A2,B:B),"")

This will only put the sum at the first instance of a new value in column A. If you want each row
to have the sum, just use

=SUMIF(A:A,A2,B:B)

HTH,
Bernie
MS Excel MVP

 

[Guest]

this part worked. a follow up is what if i have 2 columns of data to add? i
tried
d1: =SUMIF(A:A,A1,B:C) but it does't add what's in column b and c. is
there an easy way to do that?

 

[Guest]

this is exactly what i need, only to put it in the first instance. now the
question is, how do i add columns b and c? my example below only said b but
i tried what seemed logically correct and it's not working.

 

[Bernie Deitrick]

Assuming you have headers in row 1, enter this into cell C2, and copy down
to match your table:

=IF(COUNTIF($A$2:A2,A2)=1,SUMIF(A:A,A2,B:B)+SUMIF(A:A,A2,C:C),"")

This will only put the sum at the first instance of a new value in column A.
If you want each row
to have the sum, just use

=SUMIF(A:A,A2,B:B)+SUMIF(A:A,A2,C:C)

HTH,
Bernie
MS Excel MVP

 

[Guest]

d1: =SUMIF(A:A,A1,B:C)

One way is to use 2 SUMIFs, eg:
=SUMIF(A:A,A1,B:B)+SUMIF(A:A,A1,C:C)