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

If this post helps click Yes
---------------
Jacob Skaria


"bookman3" wrote:

Hi
I have 2 lists, each list has a no and value column. (cols A to D below)
I need to combine them into 1 list which is cols E & F below
here is a small example of what I am trying to do
Col A Col B Col C Col D Col E Col F
111 1 100 5 100 5
222 3 111 3 111 4
333 6 333 2 222 3
444 2 333 8
444 2

--
bookman