SUM 2 COLumns values with common names in another columns

R

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
 
P

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top