SUM if duplicate cell

[aznan]

Hi, i have tested a few formula but couldnt get this working.

I would like to compare two columns (Column A & C) and if the cells contains same string/word then to SUM the column (Column B & D) next to each of them.

The result and the unique ID to be in a two new columns (column E and F as shown on the screen shot from the link below).

If column C & D doesnt have data then just write the data from Column A and B on column E and F.

It may have confused some of you but I have uploaded a screen shot to better illustrate my objective and to clarify the confusion.


https://docs.google.com/leaf?id=0B9mbLH9AjD33ODlkZGU0NTEtYTkxZS00OTQ1LTg1Y2MtMDE0Y2ZiNWQxNWZk&hl=en

Any inputs will be highly appreciated.

Thanks in advance
Aznan Nagor

 

[Dannyh1]

Hi Try:

F1 =SUMIF(A:A,E1,B:B)+SUMIF(C:C,E1,D:D)

 

[Steeviee]

I think thais is kind of what you're looking for:

(if column E is the same as column A)

formula in cell F2=

=VLOOKUP(E2,A:B,2,FALSE)+IF(ISERROR(VLOOKUP(E2,C:D,2,FALSE)),0,VLOOKUP(E2,C:D,2,FALSE))

 

[aznan]

Guys, thanks a lot for your prompt replies, very much appreciated. Steeviee's formula worked well !!!....you're a star!!.

Regards
Aznan Nagor