Combing 2 lists of data

[bookman3]

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

 

[Jacob Skaria]

If you are looking at totalling the values of a number in E1 use the below
formula in F1

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


If this post helps click Yes

 

[Jacob Skaria]

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

If this post helps click Yes