View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ram ram is offline
external usenet poster
 
Posts: 1
Default sum 2 columns with equal names

On 20 Jan, 16:05, Luís Miguel Ramires Vieira Reis RAM
wrote:
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

thanks