Sumproduct ??

[carl]

I have my data like this (actual table is much larger):

5 7 5
20100701 200 1380 2612
20100702 2278
20100706 1501 1617
20100707 1450 1673 5220
20100708 2465 891 2590
20100709 1264
20100712 919 842

I am trying to create a table that looks like this:

5 7
20100701 2812 1380
20100702 0 2278
20100706 1617 1501
20100707 6670 1673
20100708 5055 891
20100709 0 1264
20100712 842 919

So I am looking for a formula for B2:C8 that will sum the values from
my data table based on matching values in A2:A8 and B2:B3.

I think I need a sumproduct formula but can;t get one to work.

Can someone provide the formula to do this ?

Thank you in advance.

 

[Ms-Exl-Learner]

I have created a sample file for you, Click or Copy and paste the
below link in web browser to download the Example file.

http://www.sendspace.com/file/tvuxjn

Scroll the mouse button to the bottom of the website and click
Download.

The File Name is : SUMPRODUCT SOLUTION.xls

Hope it's clear to you!