Sumproduct I think

[GSemler]

I have 2 data sheets

Sheet one has 3 colums of data
A B C
1 2 3
1 3 3
1 3 6
2 2 1
2 2 3

Sheet 2
A B
1 10
2 15

Ideal Return on Sheet 3 given Data above
A B C
1 2 3
1 3 6
2 2 4

Sheet 3 i would like to dispay coulumn A and B (summed if matching numbers)
from Sheet 1 and Column Bfrom Sheet 2. The numbers in in column A Sheet 1
are constant but vary on the number of them for example, 1 may appear only
once this week while next it may appear 5 times.

I deal with a table displaying the information, but would much prefer
columns becuase There will be more calculation i have to perform

 

[Roger Govier]

Hi

Can you provide a more detailed explanation?
I cannot see how one would get the result you show from the data provided.