SUM 2 COLumns values with common names in another columns

[ram]

hi

how can i sum 2 columns from 2 tables having in common the same names
by side of the numbers to sum?

hi
how can i sum 2 columns from 2 tables having in common the same names
by side of the numbers to sum?
table1
column1 column2
1 a
2 b
3 c
4 d
5 e
6 f
7 g
8 h
9 i
table2
col1 col2
1 b
2 d
3 a
4 f
5 c
6 f
7 g
8 h
table3
col1 col2
a ? = tab1 col1+tab2 col1
b ?
c ?
d ?
e ?
f
g
h
i
j
thanks

 

[Pete_UK]

Try this:

=SUMIF(sheet1!B:B,A1,sheet1!A:A) + SUMIF(sheet2!B:B,A1,sheet2!A:A)

Then copy down as required.

Hope this helps.

Pete

 

[ram]

Try this:

=SUMIF(sheet1!B:B,A1,sheet1!A:A) + SUMIF(sheet2!B:B,A1,sheet2!A:A)

Then copy down as required.

Hope this helps.

Pete

THANKS

but doesnt work

 

[Pete_UK]

Well, this is what I got in Sheet3, with your table1 in Sheet1 and
table2 in Sheet2:

a 4
b 3
c 8
d 6
e 5
f 16
g 14
h 16
I 9
j 0

Tell me what "doesnt work" means - what did you get?.

Pete